Re: XID wraparound and busy databases

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: XID wraparound and busy databases
Дата
Msg-id 6537.1187194711@sss.pgh.pa.us
обсуждение исходный текст
Ответ на XID wraparound and busy databases  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: XID wraparound and busy databases
Re: XID wraparound and busy databases
Re: XID wraparound and busy databases
Список pgsql-hackers
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?
        regards, tom lane


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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: XID wraparound and busy databases