XID wraparound and busy databases

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
XID wraparound and busy databases
Дата
Msg-id
200708151601.l7FG1dU14511@momjian.us
Список
Дерево обсуждения
XID wraparound and busy databases Bruce Momjian <bruce@momjian.us>
Re: XID wraparound and busy databases Heikki Linnakangas <heikki@enterprisedb.com>
Re: XID wraparound and busy databases Tom Lane <tgl@sss.pgh.pa.us>
Re: XID wraparound and busy databases "Simon Riggs" <simon@2ndquadrant.com>
Re: XID wraparound and busy databases Darcy Buskermolen <darcy@dbitech.ca>
Re: XID wraparound and busy databases Decibel! <decibel@decibel.org>
Re: XID wraparound and busy databases Tom Lane <tgl@sss.pgh.pa.us>
Re: XID wraparound and busy databases Robert Treat <xzilla@users.sourceforge.net>
Re: XID wraparound and busy databases Tom Lane <tgl@sss.pgh.pa.us>
Re: XID wraparound and busy databases "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: XID wraparound and busy databases Tom Lane <tgl@sss.pgh.pa.us>
Re: XID wraparound and busy databases Zoltan Boszormenyi <zb@cybertec.at>
Re: XID wraparound and busy databases Heikki Linnakangas <heikki@enterprisedb.com>
Re: XID wraparound and busy databases Zoltan Boszormenyi <zb@cybertec.at>
Re: XID wraparound and busy databases Bruce Momjian <bruce@momjian.us>
Re: XID wraparound and busy databases Tom Lane <tgl@sss.pgh.pa.us>
Re: XID wraparound and busy databases Bruce Momjian <bruce@momjian.us>
Re: XID wraparound and busy databases Heikki Linnakangas <heikki@enterprisedb.com>
Re: XID wraparound and busy databases "Florian G. Pflug" <fgp@phlo.org>
Re: XID wraparound and busy databases Bruce Momjian <bruce@momjian.us>
Re: XID wraparound and busy databases Paul Lindner <lindner@inuus.com>
I was talking to someone at LinuxWorld and they mentioned they often
have activity of 6k SELECTs per second, and that they were needing to
autovacuum every few days because of xid wraparound.

I did some calculations and found that:
> 6000 * 60 * 60 * 24       	518400000

or 500 million xids per day, confirming they would need the autovacuum
to run every few days.

Is enlarging the xid field something we should consider for 8.4?  Is the
autovacuum I/O less then the extra I/O needed for an expanded xid fields
on every row?

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

В списке pgsql-hackers по дате отправления
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: CVS corruption/mistagging?
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: CVS corruption/mistagging?
FAQ