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

Re: Another idea for dealing with cmin/cmax

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Another idea for dealing with cmin/cmax
Date: 2006-09-28 16:22:23
Message-ID: 20060928162223.GO34238@nasby.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Sep 28, 2006 at 05:13:11PM +0100, Heikki Linnakangas wrote:
> Jim C. Nasby wrote:
> >In addition to/instead of abstracting cmin/cmax to a phantom ID, what
> >about allowing for two versions of the tuple header, one with cid info
> >and one without? That would allow for cid info to be stripped out when
> >pages were written to disk.
> >  
> 
> How exactly would that help? You can't just strip out cid info when 
> writing to disk, if you don't want to lose the information.

Erm, sorry, brainfart... yeah, we'd need to be able to write the info
out to disk.

The reason I thought of this is because once the transaction commits, we
have no use for the cid info. So we could do something like have
bgwriter look for tuples that belong to committed transactions before it
writes a page, and strip the cid out of them.

The problem with *that* is that (AFAIK) you'll need cid info again once
you go to update or delete that tuple. And that might obviously need to
spill to disk before the transaction commits.

Back to the drawing board...
-- 
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

pgsql-hackers by date

Next:From: Luke LonerganDate: 2006-09-28 16:40:04
Subject: Re: New version of money type
Previous:From: Jeff DavisDate: 2006-09-28 16:20:10
Subject: Re: [GENERAL] 'pg_ctl -w' times out when unix_socket_directory is

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