Skip site navigation (1) Skip section navigation (2)

Re: 8.2 Autovacuum BUG ?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Mikko Partio <mpartio(at)gmail(dot)com>
Cc: Pallav Kalva <pkalva(at)livedatagroup(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: 8.2 Autovacuum BUG ?
Date: 2007-08-31 18:47:44
Message-ID: 20070831184744.GK8046@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
Mikko Partio escribi├│:

> Off-topic question: the documentation says that XID numbers are 32 bit.
> Could the XID be 64 bit when running on a 64 bit platform? That would
> effectively prevent wrap-around issues.

No, because they would take too much space in tuple headers.

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
Al principio era UNIX, y UNIX habl├│ y dijo: "Hello world\n".
No dijo "Hello New Jersey\n", ni "Hello USA\n".

In response to

Responses

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2007-08-31 18:51:28
Subject: Re: 8.2 Autovacuum BUG ?
Previous:From: Pallav KalvaDate: 2007-08-31 18:42:11
Subject: Re: 8.2 Autovacuum BUG ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group