Re: Very slow planning performance on partition table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Very slow planning performance on partition table
Дата
Msg-id 24564.1406478487@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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  (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>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Rural Hunter
Дата:
Сообщение: Re: Very slow planning performance on partition table
Следующее
От: Marc Mamin
Дата:
Сообщение: Re: Cursor + upsert (astronomical data)