Global Associative Arrays in PostgreSQL (migops.com)

Have DBA'd a huge instance with pgperlu in this role. 10/10, It just works.

That was option #3:

    Store this object in a table and load it in the function.
    
    Storing it in a Table and accessing the elements by selecting from the Table. This can be a heavy overhead.

While I can’t don’t know for sure how much overhead that is versus launching into tcl, I do avoid creating temporary tables in performance-sensitive code.

There exists a great difference in performance between creating a temp table to store the information vs using associative arrays.

And also consider multiple parallel connections in a high traffic database creating so many temp tables :(

One of the problem with temporary tables is that it will result in adding metadata information into PostgreSQL catalog (pg_class), and it will easily get bloated as the temporary table ends its life