Re: [DOCS] Autovacuum and XID wraparound

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: [DOCS] Autovacuum and XID wraparound
Дата
Msg-id 20070516002500.GG20707@nasby.net
обсуждение исходный текст
Ответ на Re: [DOCS] Autovacuum and XID wraparound  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: [DOCS] Autovacuum and XID wraparound  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-patches
On Tue, May 15, 2007 at 06:13:47PM -0400, Alvaro Herrera wrote:
> Tom Lane wrote:
> > Alvaro Herrera <alvherre@commandprompt.com> writes:
> > > I suppose it would be pretty trivial to set the relfrozenxid to
> > > RecentXmin or something during TRUNCATE.
> >
> > I had the idea we were doing that already --- at least I'm pretty sure I
> > remember it being discussed.  But I see it's not being done in HEAD.
>
> Patch to do it attached.  I am thinking we can do something similar in
> CLUSTER as well.

Actually, it already happens for CLUSTER because cluster calls
heap_create_with_catalog, which calls AddNewRelationTuple. See
backend/catalog/heap.c line 716.
--
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Automatic adjustment of bgwriter_lru_maxpages
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [DOCS] OS/X startup scripts