Re: Reduce heap tuple header size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)atentus(dot)com>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Manfred Koizar <mkoi-pg(at)aon(dot)at>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Reduce heap tuple header size
Date: 2002-06-22 20:56:29
Message-ID: 4451.1024779389@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> So it saves less than 3% disk space at the cost of about 9% performance
> loss.
>
> Uh ... isn't more TPS better?

> 9%, that is a dramatic difference.

Yup. I'm suspicious of it --- if the database is 3% smaller then I'd
believe a 3% performance gain from reduction of I/O, but I don't see
where 9% comes from.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-06-22 21:45:09 Re: Hash and bools
Previous Message Robert Kernell 2002-06-22 16:48:12 computer for todo list

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2002-06-22 21:17:36 Re: ODBC Patch to prevent setting of KSQO on 7.3+ servers
Previous Message Dave Page 2002-06-22 19:56:20 Re: ODBC Patch to prevent setting of KSQO on 7.3+ servers