Re: patch submission: truncate trailing nulls from heap
rows to reduce the size of the null bitmap
From:
Josh Berkus <josh(at)agliodbs(dot)com>
To:
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: patch submission: truncate trailing nulls from heap
rows to reduce the size of the null bitmap
Date:
2012-05-03 01:01:38
Message-ID:
4FA1D8F2.8000009@agliodbs.com (view raw or flat )
Thread:
2012-04-17 16:22:42 from Jameison Martin <jameisonb(at)yahoo(dot)com>
2012-04-17 16:38:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-04-17 20:27:55 from Greg Stark <stark(at)mit(dot)edu>
2012-04-17 20:42:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-04-17 20:56:02 from Jameison Martin <jameisonb(at)yahoo(dot)com>
2012-04-18 04:57:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-04-18 05:50:00 from Jameison Martin <jameisonb(at)yahoo(dot)com>
2012-04-26 00:35:37 from Jameison Martin <jameisonb(at)yahoo(dot)com>
2012-04-26 07:27:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-26 13:42:19 from Greg Stark <stark(at)mit(dot)edu>
2012-04-26 18:59:01 from Jameison Martin <jameisonb(at)yahoo(dot)com>
2012-05-02 17:20:13 from Jameison Martin <jameisonb(at)yahoo(dot)com>
2012-05-03 01:01:38 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-05-03 18:52:18 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-06-26 21:04:42 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-27 00:51:17 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-04-27 10:06:02 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-28 22:23:01 from Greg Stark <stark(at)mit(dot)edu>
2012-04-28 23:24:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-29 11:19:03 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-29 11:50:49 from Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
2012-04-29 21:02:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-09 10:14:33 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-08-09 14:27:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-09 14:49:11 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-08-09 15:56:14 from Jameison Martin <jameisonb(at)yahoo(dot)com>
2012-08-09 22:57:51 from Jim Nasby <jim(at)nasby(dot)net>
2012-08-10 00:06:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
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.conf can 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
In response to
Responses
pgsql-hackers by date
Next :From: Noah MischDate: 2012-05-03 01:06:48
Subject : Re: Torn page hazard in ginRedoUpdateMetapage()
Previous :From : Josh BerkusDate : 2012-05-03 00:57:19
Subject : Re: Temporary tables under hot standby