l but one use case (wide tables)
that stalled things.
>
> From: Josh Berkus
>To: Simon Riggs
>Cc: Tom Lane ; Amit Kapila ;
>Andres Freund ; Craig Ringer ;
>Jameison Martin ; Noah Misch ; Kevin
>Grittner ; robertmh...@gmail.com;
>
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 du
d like to introduce the topic and get
some feedback on the right way to communicate as early as possible.
Thanks.
-Jamie
________
From: Tom Lane
To: Simon Riggs
Cc: Jameison Martin ; "pgsql-hackers@postgresql.org"
Sent: Thursday, August 9, 2012 7:27 AM
ers.
-Jamie
____
From: Simon Riggs
To: Jameison Martin
Cc: Tom Lane ; "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 of the
,
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
To: Jameison Martin
Cc: "pgsql-hackers@post
Lane
To: Jameison Martin
Cc: "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 writes:
> The use-case I'm targeti
ks.
-jamie
From: Tom Lane
To: Jameison Martin
Cc: "pgsql-hackers@postgresql.org"
Sent: Tuesday, April 17, 2012 9:38 AM
Subject: Re: [HACKERS] patch submission: truncate trailing nulls from heap rows
to reduce the size of the null bitmap
Jam
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 add
