From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Noah Misch <noah(at)leadboat(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin |
Date: | 2014-08-07 13:39:57 |
Message-ID: | CA+TgmoZp_LmpTWLguUQ2putrvFmnD47FaARXcdS_XQ6KPAuOuQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Aug 6, 2014 at 9:35 PM, 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?
>>
>> 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?
Well, it would be helpful if he could describe the defect he found, so
that the next person doesn't have to guess.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2014-08-07 13:52:27 | Re: Fixed redundant i18n strings in json |
Previous Message | Fujii Masao | 2014-08-07 13:34:50 | Re: HEAD crashes with assertion and LWLOCK_STATS enabled |