Postgres Pro
Downloads
Home   >   mailing lists

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

From Gregory Stark
Subject Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent
Date
Msg-id 87d4rheoyi.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pgsql: Add checks to TRUNCATE, CLUSTER, and REINDEX to prevent  (Bruce Momjian <bruce@momjian.us>)
List pgsql-committers
Tree view 
"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 by date:

Previous
From: qnex@pgfoundry.org (User Qnex)
Date:
Subject: press - pr: Updated release.txt to the current version
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Remove the old table of "supported platforms" in favor of a link