Re: Reduce heap tuple header size - Mailing list pgsql-patches

From Tom Lane
Subject Re: Reduce heap tuple header size
Date
Msg-id 4451.1024779389@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reduce heap tuple header size  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.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

pgsql-patches by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Schemas for psql
Next
From: Tom Lane
Date:
Subject: Re: [ODBC] ODBC Patch to prevent setting of KSQO on 7.3+ servers