Re: BUG #16373: Behavior of Temporary table creation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16373: Behavior of Temporary table creation
Дата
Msg-id 19190.1587130449@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16373: Behavior of Temporary table creation  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16373: Behavior of Temporary table creation  (Hritik Gupta <hritik122@gmail.com>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> Hi! Have a small doubt I’m hoping you can help me with..simply put, where
> are the temporary tables created? 

> AFAIK, they stay in the memory till the size reaches the temp_buffers limit,
> and then to the storage, for where it is accessed using the temp buffer,

They are accessed through temp buffers, yes, but storage space gets
reserved on-disk immediately whenever the relation is extended.
This is the same as for non-temp tables.

            regards, tom lane



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jehan-Guillaume de Rorthais
Дата:
Сообщение: Re: [BUG] non archived WAL removed during production crash recovery
Следующее
От: David Kubecka
Дата:
Сообщение: Possibly misleading documentation of Template Patterns for Date/Time Formatting