Re: Remove xmin and cmin from frozen tuples - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Remove xmin and cmin from frozen tuples
Date
Msg-id 200509021335.43256.josh@agliodbs.com
Whole thread Raw
In response to Re: Remove xmin and cmin from frozen tuples  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Remove xmin and cmin from frozen tuples
List pgsql-hackers
People:

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Considering the cost/benefits, rather than doing some optimization for
> > long-lived tuples, I would like to see us merge the existing
> > xmin/xmax/cmin/cmax values back into three storage fields like we had
> > in 7.4 and had to expand to a full four in 8.0 to support
> > subtransactions.

Hmmm.   I personally don't see a whole lot of value in trimming 4 bytes per 
row off an archive table, particularly if the table would need to go 
through some kind of I/O intensive operation to do it.

Where I do see value is in enabling index-only access for "frozen" tables.  
That would be a *huge* gain, especially with bitmaps.   I think we've 
discussed this before,though.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Remove xmin and cmin from frozen tuples
Next
From: Tom Lane
Date:
Subject: Re: Procedural language definitions (was Re: 8.1 and syntax checking at create time)