4 ms·
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 t
by zeroimpl 6y ago
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.
- 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.