Postgres Pro
Downloads
Home   >   mailing lists

Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Date
Msg-id 4FA1D8F2.8000009@agliodbs.com
Whole thread Raw
In response to Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap  (Jameison Martin <jameisonb@yahoo.com>)
Responses Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
List pgsql-hackers
Tree view 
On 5/2/12 10:20 AM, Jameison Martin wrote:
> Attached are the following as per various requests:
>     * test_results.txt: the performance benchmarking results, 
> 
>     * TestTrailingNull.java: the performance benchmarking code, with a few additional scenarios as per various
requests
> 
>     * hardinfo_report.txt: some information about the hardware and OS of the system on which the benchmarks were run,
and
> 
>     * postgresql.conf: the postgresql.conf used when running benchmarks. Note that the changes made to the vanilla
postgresql.confcan be identified by looking for the string 'jamie' in the file I attached (there aren't that many)
 

Nice, thanks.  I'll try some of my own tests when I get a chance; I have
a really good use-case for this optimization.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Temporary tables under hot standby
Next
From: Noah Misch
Date:
Subject: Re: Torn page hazard in ginRedoUpdateMetapage()