Re: [Fwd: Re: [PATCHES] 64-bit CommandIds] - Mailing list pgsql-hackers

From Decibel!
Subject Re: [Fwd: Re: [PATCHES] 64-bit CommandIds]
Date
Msg-id 7B2F9AD1-9D7F-43A9-BF81-87FEA2F45B3F@decibel.org
Whole thread Raw
In response to Re: [Fwd: Re: [PATCHES] 64-bit CommandIds]  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: [Fwd: Re: [PATCHES] 64-bit CommandIds]  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
On Mar 10, 2008, at 12:06 PM, Heikki Linnakangas wrote:
> Gregory Stark wrote:
>> I don't understand. The patch only affects configuration and SQL  
>> data type
>> code. It doesn't actually store the 64-bit commandid anywhere  
>> which would be
>> the actual hard part.
>
> Sure it does, this is the significant part of the patch:
>
> *** pgsql.orig/src/include/c.h    2008-03-02 13:44:45.000000000 +0100
> --- pgsql-cid64/src/include/c.h    2008-03-04 21:05:23.000000000 +0100
> *************** typedef TransactionId MultiXactId;
> *** 382,388 ****
> --- 382,392 ----
>
>   typedef uint32 MultiXactOffset;
>
> + #ifdef USE_64BIT_COMMANDID
> + typedef uint64 CommandId;
> + #else
>   typedef uint32 CommandId;
> + #endif
>
>   #define FirstCommandId    ((CommandId) 0)
>
> CommandId type is used in htup.h and elsewhere, which changes the  
> on-disk format.

If we're going to make this a ./configure option, ISTM we should do  
the same with XID size as well. I know there are high-velocity  
databases that could use that.
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: Patch to update libpqxx's homepage in README
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Unique Constraints using Non-Unique Indexes