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	July 27, 2014 16:28:15
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 Re: Very slow planning performance on partition table Re: Very slow planning performance on partition table Re: Very slow planning performance on partition table
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:

From: Rural Hunter
Date: 27 July 2014, 15:44:25
Subject: Re: Very slow planning performance on partition table

From: Marc Mamin
Date: 27 July 2014, 19:05:40
Subject: Re: Cursor + upsert (astronomical data)

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

Previous

Next