Re: BUG #6741: ExclusiveLock on extension of relation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #6741: ExclusiveLock on extension of relation
Дата
Msg-id 12878.1342544964@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #6741: ExclusiveLock on extension of relation  (ryseq@hotmail.com)
Список pgsql-bugs
ryseq@hotmail.com writes:
> i have  been getting the  message below in the  logs  whats causes these
> statements to appear in the logs?

>   process 11812 acquired ExclusiveLock on extension of relation 60777 of
> database 16387 after 1392.303 ms
> LOG:  process 24079 still waiting for ExclusiveLock on extension of relation
> 60777 of database 16387 after 1000.183 ms

Apparently you've got log_lock_waits turned on.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: ryseq@hotmail.com
Дата:
Сообщение: BUG #6741: ExclusiveLock on extension of relation
Следующее
От: Chan Pham
Дата:
Сообщение: Re: log_truncate_on_rotation=on is not truncating