Re: XID wraparound and busy databases

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: XID wraparound and busy databases
Дата
Msg-id 46C34CB1.3030606@enterprisedb.com
обсуждение исходный текст
Ответ на Re: XID wraparound and busy databases  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
>> Is enlarging the xid field something we should consider for 8.4?
> 
> No.  We just got the tuple header down to 24 bytes, we are not going
> to give that back and then some.
> 
> If you are processing 6K transactions per second, you can afford to
> vacuum every couple days... and probably need to vacuum much more often
> than that anyway, to avoid table bloat.

Speaking of vacuum, hopefully we'll get some sort of dead space map in
8.4. If we keep track of frozen pages there, vacuuming to avoid xid
wraparound will be much cheaper.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: CVS corruption/mistagging?
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Another idea for index-only scans