Re: Single pass vacuum - take 1 - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Single pass vacuum - take 1
Date
Msg-id 1310668936-sup-1775@alvh.no-ip.org
Whole thread Raw
In response to Re: Single pass vacuum - take 1  (Pavan Deolasee <pavan.deolasee@gmail.com>)
List pgsql-hackers
Excerpts from Pavan Deolasee's message of jue jul 14 13:54:36 -0400 2011:
> On Thu, Jul 14, 2011 at 12:43 PM, Heikki Linnakangas <
> heikki.linnakangas@enterprisedb.com> wrote:

> > Seems odd to store relindxvacxlogid/off as two int32 columns. Store it in
> > one uint64 column, or invent a new datatype for LSNs, or store it as text in
> > %X/%X format.
> >
> >
> Yeah. I don't remember what issues I faced with uint64 column, may be did
> not get around the case where uint64 is not natively supported on the
> platform. But %X/%X looks very reasonable. Will change to that.

Where is this to be stored?

AFAIR we no longer support platforms that do not have working 64 bit
integer types.

As a column name, relindxvacxlogid seems a bit unfortunate, BTW ...

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: Need help understanding pg_locks
Next
From: Josh Berkus
Date:
Subject: Re: Allow pg_archivecleanup to ignore extensions