Postgres Pro
Downloads
Home   >   mailing lists

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 20140111191001.GI28089@momjian.us
Whole thread Raw
In response to Partitioning performance: cache stringToNode() of pg_constraint.ccbin  (Noah Misch <noah@leadboat.com>)
Responses Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
Tree view 
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?

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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: units in postgresql.conf comments
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: newlines at end of generated SQL