Horton

Re: foreign key locks, 2nd attempt

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-hackers@postgresql.org
Date: 2011-11-11T22:02:00Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Try to avoid running with a full fsync request queue.

>> An UPDATE that modifies the key columns will be blocked, just as now.
>> Same with a DELETE.
> 
> OK, so it prevents non-key data modifications from spilling to the
> referred rows --- nice.

Yes.  Eliminates the leading cause of deadlocks in Postgres applications.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com