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

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

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2014-01-11 19:23:46 Re: newlines at end of generated SQL
Previous Message Bruce Momjian 2014-01-11 19:06:48 Re: units in postgresql.conf comments