Quick Links

Re: Very slow planning performance on partition table

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Rural Hunter <ruralhunter(at)gmail(dot)com>
Cc:	"pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: Very slow planning performance on partition table
Date:	2014-07-27 16:28:07
Message-ID:	24564.1406478487@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin pgsql-performance

Rural Hunter <ruralhunter(at)gmail(dot)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

In response to

Re: Very slow planning performance on partition table at 2014-07-27 15:44:09 from Rural Hunter

Responses

Re: Very slow planning performance on partition table at 2014-07-28 01:18:59 from Rural Hunter
Re: Very slow planning performance on partition table at 2014-07-28 13:10:32 from Rural Hunter
Re: Very slow planning performance on partition table at 2014-07-28 17:29:25 from Jeff Janes
Re: Very slow planning performance on partition table at 2014-08-04 07:23:11 from Rural Hunter

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Rural Hunter	2014-07-28 01:18:59	Re: Very slow planning performance on partition table
Previous Message	Rural Hunter	2014-07-27 15:44:09	Re: Very slow planning performance on partition table

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Marc Mamin	2014-07-27 19:05:22	Re: Cursor + upsert (astronomical data)
Previous Message	Rural Hunter	2014-07-27 15:44:09	Re: Very slow planning performance on partition table