Re: Reduce heap tuple header size

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Manfred Koizar <mkoi-pg(at)aon(dot)at>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Reduce heap tuple header size
Date: 2002-06-20 23:09:02
Message-ID: 200206202309.g5KN92O29783@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Tom Lane wrote:
> >> Are you planning to ignore my objections to it?
>
> > The author replied addressing your objections and I saw no reply from on
> > on that.
>
> He replied stating his opinion; my opinion didn't change. I was waiting
> for some other people to weigh in with their opinions. As far as I've
> seen, no one else has commented at all.
>
> If I get voted down on the point after suitable discussion, so be it.
> But I will strongly object to you applying the patch just because it's
> next in your inbox.

Tom, I have reviewed your objections:

> As I commented before, I am not in favor of this. I don't think that a
> four-byte savings justifies a forced initdb with no chance of
> pg_upgrade, plus loss of redundancy (= reduced chance of detecting or
> recovering from corruption), plus significantly slower access to
> several critical header fields. The tqual.c routines are already
> hotspots in many scenarios. I believe this will make them noticeably
> slower.

I don't think enough people use pg_upgrade to make it a reason to keep
an extra four bytes of tuple overhead. I realize 8-byte aligned systems
don't benefit, but most of our platforms are 4-byte aligned. I don't
consider redundency a valid reason either. We just don't have many
table corruption complaints, and the odds that having an extra 4 bytes
is going to make detection or correction better is unlikely.

The author addressed the slowness complaint and seemed to refute the
idea it would be slower.

Is there something I am missing?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-06-21 00:12:23 Re: cvs read lock
Previous Message David M. Kaplan 2002-06-20 22:48:09 Adding encrypted identd authetification

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-06-20 23:48:24 Re: pg_dumpall should permit quiet operation
Previous Message Bruce Momjian 2002-06-20 21:38:05 Re: Patch for memory leaks in index scan