View Single Post

   
  #10 (permalink)  
Old 04-12-2008, 06:02 AM
Jim C. Nasby
 
Posts: n/a
Default Re: Another idea for dealing with cmin/cmax

On Fri, Sep 29, 2006 at 01:15:06PM +0900, ITAGAKI Takahiro wrote:
>
> "Jim C. Nasby" <jim@nasby.net> wrote:
>
> > 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.

>
> Your concept is just like as the experimental method that I suggested before
> in http://archives.postgresql.org/pgsql...8/msg01193.php
> We can remove cmin and cmax from commited tuples and xmin from frozen tuples
> and we might save some bytes in tuple headers.
>
> However, I think our next goal to shrink the headers is 16 bytes. The headers
> become 23 bytes using phantom cids and we are limited by alignments, so we will
> have no more advantages unless we delete extra 7 bytes in the headers.
> ...and it seems to be very difficult.


Dumb question... wouldn't getting down to 20 bytes buy us something?
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote