Re: ADD FOREIGN KEY locking

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: James Sewell <james(dot)sewell(at)lisasoft(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ADD FOREIGN KEY locking
Date: 2015-02-18 02:30:43
Message-ID: CAB7nPqQ9+O2FZR3SbOaF5DcupXBFKSra_wWdf7tbC7NmXBWEFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Feb 18, 2015 at 9:06 AM, James Sewell <james(dot)sewell(at)lisasoft(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2015-02-18 06:12:38 Re: pgaudit - an auditing extension for PostgreSQL
Previous Message Petr Jelinek 2015-02-18 02:02:13 Re: Sequence Access Method WIP