Re: TRUNCATE - timing of the return of disk space - caused by long-lived client?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: TRUNCATE - timing of the return of disk space - caused by long-lived client?
Дата
Msg-id 9415.1193401302@sss.pgh.pa.us
обсуждение исходный текст
Ответ на TRUNCATE - timing of the return of disk space - caused by long-lived client?  ("Vince Negri" <vnegri@asl-electronics.co.uk>)
Ответы Re: TRUNCATE - timing of the return of disk space - caused by long-lived client?  ("Vince Negri" <vnegri@asl-electronics.co.uk>)
Список pgsql-general
Дерево обсуждения 
"Vince Negri" <vnegri@asl-electronics.co.uk> writes:
> What causes the file handles of the truncated table to be released by all postmaster processes?

It should happen when the other backends process the sinval message
about the TRUNCATE, which at the latest should be the next time they
begin command execution.  What were the other clients doing, just
sitting idle?

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: TRUNCATE - timing of the return of disk space - caused by long-lived client?
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: How to ALTER a TABLE to change the primary key?