po 9. 11. 2020 v 13:07 odesílatel Yambu <hyambu@gmail.com> napsal:
Hi
May I know if a temporary table is dropped at the end of a function?
PostgreSQL temporary tables can be dropped on the end of transaction or end of session.
Also may I know if excessive use of temporary tables may cause locks?
Usually there are no problems with locks, but there is a problem with system tables bloating. Creating and dropping temp tables is expensive like creating or dropping normal tables.
Against other databases, there can be used arrays instead temporary tables. This is significantly more effective.