Re: XID wraparound and busy databases

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: XID wraparound and busy databases
Дата
Msg-id 200708151620.l7FGK3H07904@momjian.us
обсуждение исходный текст
Ответ на 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.
> 
> Possibly your respondent should think about trying to do more than one
> thing per transaction?

OK, yea, I think that makes sense.

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: XID wraparound and busy databases
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: CVS corruption/mistagging?