Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent - Mailing list pgsql-committers

From Bruce Momjian
Subject Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent
Date
Msg-id 200801311504.m0VF4vi13802@momjian.us
Whole thread Raw
In response to Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent
List pgsql-committers
Tree view 
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > You want a TODO for 3883?
>
> Yeah, I would like to have some positive detection for deadlocks
> involving LockBufferForCleanup().  What is unclear is how the heck
> to do that without adding unacceptable overhead to buffer pin/unpin.

OK, added to TODO:

    * Improve deadlock detection when deleting items from shared buffers

      http://archives.postgresql.org/pgsql-bugs/2008-01/msg00138.php
      http://archives.postgresql.org/pgsql-hackers/2008-01/msg00873.php
      http://archives.postgresql.org/pgsql-committers/2008-01/msg00365.php

Let me know if there is better wording.

--
  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 by date:

Previous
From: mha@pgfoundry.org (User Mha)
Date:
Subject: pginstaller - pginst: Another attempt at the ukranian translation -
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add: > * Improve deadlock detection when deleting items from