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 по дате отправления