Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent
Дата
Msg-id 87d4rheoyi.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-committers
"Bruce Momjian" <bruce@momjian.us> writes:

>     * Improve deadlock detection when deleting items from shared buffers
>...
> Let me know if there is better wording.

I'm not sure whhere deleting items from shared buffers enters into it.

I think you need something like:

Add deadlock detection when a process holding a buffer pin is blocked by a
lock held by a process attempting to LockBufferForCleanup() on that buffer or
more complex versions thereof. (And without adding unacceptable overhead to
pin/unpin.)

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning

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

Предыдущее
От: qnex@pgfoundry.org (User Qnex)
Дата:
Сообщение: press - pr: Updated release.txt to the current version
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Remove the old table of "supported platforms" in favor of a link