Hi
po 9. 11. 2020 v 13:07 odesílatel Yambu <hyambu(at)gmail(dot)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.
Regards
Pavel
> regards
>