Re: Temporary tables usage in functions
| От | Pavel Stehule |
|---|---|
| Тема | Re: Temporary tables usage in functions |
| Дата | |
| Msg-id | CAFj8pRC1ima-xi1MMnuaa+a89Z+b=m4z1Yp6MF7t2q0abZ8+dg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Temporary tables usage in functions (Yambu <hyambu@gmail.com>) |
| Ответы |
Re: Temporary tables usage in functions
|
| Список | pgsql-general |
Hi
po 9. 11. 2020 v 13:07 odesílatel Yambu <hyambu@gmail.com> napsal:
HiMay 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
В списке pgsql-general по дате отправления: