Re: [HACKERS] Partitioning performance: cache stringToNode() of pg_constraint.ccbin

On Thu, Aug 7, 2014 at 3:35 AM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
> 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?

Bob!

> > 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(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers