Re: AutoVacuum Behaviour Question

Поиск
Список
Период
Сортировка
От Jeff Amiel
Тема Re: AutoVacuum Behaviour Question
Дата
Msg-id 4729DC53.50107@istreamimaging.com
обсуждение исходный текст
Ответ на Re: AutoVacuum Behaviour Question  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: AutoVacuum Behaviour Question  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general

Bruce Momjian wrote:

No, it isn't.  Please add a TODO item about it:* Prevent long-lived temp tables from causing frozen-Xid advancement  starvation   
 

Can somebody explain this one to me?  because of our auditing technique, we have many LONG lived temp tables.....(one per pooled connection)...so as long as the pool isn't disturbed, these temp tables can exist for a long time (weeks....months?)

(previous thread about our use of temp tables and autovacuum/xid issues)
http://archives.postgresql.org/pgsql-general/2007-01/msg00690.php
http://archives.postgresql.org/pgsql-general/2007-01/msg00691.php



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

Предыдущее
От: piotr_sobolewski
Дата:
Сообщение: select random order by random
Следующее
От: Lee Keel
Дата:
Сообщение: Re: select random order by random