3 ms·
Couldn't you just use a temporary table?
by phibz 6y ago
Couldn't you just use a temporary table?
- zeroimpl 6y agoThat 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.
- avi_vallarapu 6y agoYes, TCL seems to be ultra fast in comparison. And it is good to avoid temporary tables when performance is the major criteria
- phibz 6y agoTemporary tables in postgresql are pretty fast, last for the duration of the session, and integrate with any procedural language in PG. There's a lot to like there.
- avi_vallarapu 6y agoThere 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 :(
- jobinau 6y agoOne 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