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

From Amit Kapila
Subject Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap [Review]
Date
Msg-id 00b301cdee61$b9994340$2ccbc9c0$@kapila@huawei.com
Whole thread Raw
In response to Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap [Review]  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Wednesday, January 09, 2013 4:52 PM Simon Riggs wrote:
> On 24 December 2012 16:57, Amit Kapila <amit.kapila@huawei.com> wrote:
> 
> > Performance: Average of 3 runs of pgbench in tps
> > 9.3devel  |  with trailing null patch
> > ----------+--------------------------
> > 578.9872  |   573.4980
> 
> On balance, it would seem optimizing for this special case would
> affect everybody negatively; not much, but enough. Which means we
> should rekect this patch.
> 
> Do you have a reason why a different view might be taken?

I have tried to dig why this gap is coming. I have observed that there is
very less change in normal path.
I wanted to give it some more time to exactly find if something can be done
to avoid performance dip in normal execution.

Right now I am busy in certain other work. But definitely in coming week or
so, I shall spare time to work on it again.

With Regards,
Amit Kapila.




pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Further pg_upgrade analysis for many tables
Next
From: Amit Kapila
Date:
Subject: Re: Performance Improvement by reducing WAL for Update Operation