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

From: Noah Misch <noah(at)leadboat(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin
Date: 2014-01-12 17:53:40
Message-ID: 20140112175340.GA1729862@tornado.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
Noah Misch
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-01-12 18:04:30 Re: Compiling extensions on Windows
Previous Message Tom Lane 2014-01-12 17:48:40 Re: [GENERAL] pg_upgrade & tablespaces