...@2ndquadrant.com;
Jameison Martin jameis...@yahoo.com; Noah Misch n...@leadboat.com; Kevin
Grittner kgri...@mail.com; robertmh...@gmail.com;
pgsql-hackers@postgresql.org
Sent: Monday, June 24, 2013 10:32 PM
Subject: Re: [HACKERS] patch submission: truncate trailing nulls from heap
rows to reduce the size
Sorry for the late response, I just happened to see this yesterday.
Running a general benchmark against the patch as Keven suggests is a good idea.
Amit, can you supply the actual values you saw when running pgbench (the 3
values for each run)? I'd like to verify that the 1% difference isn't
way to communicate as early as possible.
Thanks.
-Jamie
From: Tom Lane t...@sss.pgh.pa.us
To: Simon Riggs si...@2ndquadrant.com
Cc: Jameison Martin jameis...@yahoo.com; pgsql-hackers@postgresql.org
pgsql-hackers@postgresql.org
Sent: Thursday, August 9, 2012 7
Riggs si...@2ndquadrant.com
To: Jameison Martin jameis...@yahoo.com
Cc: Tom Lane t...@sss.pgh.pa.us; pgsql-hackers@postgresql.org
pgsql-hackers@postgresql.org
Sent: Thursday, April 26, 2012 12:27 AM
Subject: Re: [HACKERS] patch submission: truncate trailing nulls from heap rows
to reduce the size
,
probably not statistically relevant
By slightly faster I'm talking on order of 10 nanoseconds per row.
I think #2 is explained by the reduction in loop iterations in
heap_fill_tuple().
From: Tom Lane t...@sss.pgh.pa.us
To: Jameison Martin jameis...@yahoo.com
Cc
The following patch truncates trailing null attributes from heap rows to reduce
the size of the row bitmap.
Applications often have wide rows in which many of the trailing column values
are null. On an insert/update, all of the trailing null columns are tracked in
the row bitmap. This can
From: Tom Lane t...@sss.pgh.pa.us
To: Jameison Martin jameis...@yahoo.com
Cc: pgsql-hackers@postgresql.org pgsql-hackers@postgresql.org
Sent: Tuesday, April 17, 2012 9:38 AM
Subject: Re: [HACKERS] patch submission: truncate trailing nulls from heap rows
t...@sss.pgh.pa.us
To: Jameison Martin jameis...@yahoo.com
Cc: pgsql-hackers@postgresql.org pgsql-hackers@postgresql.org
Sent: Tuesday, April 17, 2012 9:57 PM
Subject: Re: [HACKERS] patch submission: truncate trailing nulls from heap rows
to reduce the size of the null bitmap
Jameison Martin