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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent
Дата
Msg-id 200802010241.m112f1r04410@momjian.us
обсуждение исходный текст
Ответ на Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-committers
Gregory Stark wrote:
> "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.)

Text updated:

    * Improve deadlock detection when a page cleaning lock conflicts
      with a shared buffer that is pinned

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Update item: < * Improve deadlock detection when deleting items
Следующее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Update FAQ for most recent release as 8.3.