Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin
Date
Msg-id 20140807013516.GB17563@momjian.us
Whole thread Raw
In response to Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin  (Noah Misch <noah@leadboat.com>)
Responses Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin
List pgsql-hackers
On Sun, Jan 12, 2014 at 12:53:40PM -0500, Noah Misch wrote:
> On Sat, Jan 11, 2014 at 02:10:01PM -0500, Bruce Momjian wrote:
> > On Mon, Jun  3, 2013 at 03:07:27PM -0400, Noah Misch wrote:
> > > A colleague, Korry Douglas, observed a table partitioning scenario where
> > > deserializing pg_constraint.ccbin is a hot spot.  The following test case, a
> > > simplification of a typical partitioning setup, spends 28% of its time in
> > > stringToNode() and callees thereof:
> > 
> > Noah, what is the status on this?
> 
> Further study revealed a defect in the patch's memory management, and I have
> not gotten around to correcting that.

I talked to Noah and he can't continue on this item.  Can someone else
work on it?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Reporting the commit LSN at commit time
Next
From: Mitsumasa KONDO
Date:
Subject: Re: add modulo (%) operator to pgbench