Re: Very slow planning performance on partition table

Поиск
Список
Период
Сортировка
От Rural Hunter
Тема Re: Very slow planning performance on partition table
Дата
Msg-id 53D5A503.5060406@gmail.com
обсуждение исходный текст
Ответ на Re: Very slow planning performance on partition table  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Very slow planning performance on partition table
Список pgsql-performance
Дерево обсуждения 
Yes I checked. The connection I inspected is the longest running one.
There was no other connections blocking it. And I also see all locks are
granted for it. Does the planning phase require some internal locks?

在 2014/7/28 0:28, Tom Lane 写道:
> 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 по дате отправления:

Предыдущее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: Cursor + upsert (astronomical data)
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: High rate of transaction failure with the Serializable Isolation Level