Home > mailing lists

Re: ADD FOREIGN KEY locking - Mailing list pgsql-hackers

From	Michael Paquier
Subject	Re: ADD FOREIGN KEY locking
Date	February 18, 2015 05:30:53
Msg-id	CAB7nPqQ9+O2FZR3SbOaF5DcupXBFKSra_wWdf7tbC7NmXBWEFg@mail.gmail.com Whole thread Raw
In response to	Re: ADD FOREIGN KEY locking (James Sewell <james.sewell@lisasoft.com>)
List	pgsql-hackers

On Wed, Feb 18, 2015 at 9:06 AM, James Sewell <james.sewell@lisasoft.com> wrote:

I've just noticed something in the Commit fest post
- Reducing lock strength of trigger and foreign key DDL

This reduces the lock taken for ADD FOREIGN KEY to ShareRowExclusiveLock, authorizing SELECT and SELECT FOR [SHARE | UPDATE ... ].

Perhaps I just need to be more patient.

Yup.

Michael

From: Petr Jelinek
Date: 18 February 2015, 05:02:22
Subject: Re: Sequence Access Method WIP

From: Abhijit Menon-Sen
Date: 18 February 2015, 09:12:47
Subject: Re: pgaudit - an auditing extension for PostgreSQL