Postgres Pro
Downloads
Home   >   mailing lists

Re: Very slow planning performance on partition table - Mailing list pgsql-performance

From Tom Lane
Subject Re: Very slow planning performance on partition table
Date
Msg-id 24564.1406478487@sss.pgh.pa.us
Whole thread Raw
In response to Re: Very slow planning performance on partition table  (Rural Hunter <ruralhunter@gmail.com>)
Responses Re: Very slow planning performance on partition table  (Rural Hunter <ruralhunter@gmail.com>)
Re: Very slow planning performance on partition table  (Rural Hunter <ruralhunter@gmail.com>)
Re: Very slow planning performance on partition table  (Jeff Janes <jeff.janes@gmail.com>)
Re: Very slow planning performance on partition table  (Rural Hunter <ruralhunter@gmail.com>)
List pgsql-performance
Tree view 
Rural Hunter <ruralhunter@gmail.com> writes:
>> Does that indicate something? seems it's waiting for some lock.

Yeah, that's what the stack trace suggests.  Have you looked into pg_locks
and pg_stat_activity to see which lock it wants and what's holding said
lock?

            regards, tom lane

pgsql-performance by date:

Previous
From: Rural Hunter
Date:
Subject: Re: Very slow planning performance on partition table
Next
From: Marc Mamin
Date:
Subject: Re: Cursor + upsert (astronomical data)