| 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-08-07 01:35:16 |
| Message-ID: | 20140807013516.GB17563@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mitsumasa KONDO | 2014-08-07 02:20:16 | Re: add modulo (%) operator to pgbench |
| Previous Message | Craig Ringer | 2014-08-07 01:15:50 | Reporting the commit LSN at commit time |