XID wraparound and busy databases

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: XID wraparound and busy databases
Date: 2007-08-15 16:01:39
Message-ID: 200708151601.l7FG1dU14511@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2007-08-15 16:07:02 Re: CVS corruption/mistagging?
Previous Message Stefan Kaltenbrunner 2007-08-15 16:00:38 Re: CVS corruption/mistagging?