Thread: Re: [COMMITTERS] pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini
Re: [COMMITTERS] pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini
From
Bernd Helmle
Date:
--On 8. Februar 2011 12:24:11 +0000 Simon Riggs <simon@2ndQuadrant.com>
wrote:
> Extend ALTER TABLE to allow Foreign Keys to be added without initial
> validation. FK constraints that are marked NOT VALID may later be
> VALIDATED, which uses an ShareUpdateExclusiveLock on constraint table and
> RowShareLock on referenced table. Significantly reduces lock strength and
> duration when adding FKs. New state visible from psql.
Hi Simon,
It seems this commit misses updates to system catalogs documentation
regarding pg_constraint.conisvalidated.
Bernd
Re: [COMMITTERS] pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini
From
Simon Riggs
Date:
On Tue, 2011-02-08 at 22:58 +0100, Bernd Helmle wrote: > > --On 8. Februar 2011 12:24:11 +0000 Simon Riggs <simon@2ndQuadrant.com> > wrote: > > > Extend ALTER TABLE to allow Foreign Keys to be added without initial > > validation. FK constraints that are marked NOT VALID may later be > > VALIDATED, which uses an ShareUpdateExclusiveLock on constraint table and > > RowShareLock on referenced table. Significantly reduces lock strength and > > duration when adding FKs. New state visible from psql. > > Hi Simon, > > It seems this commit misses updates to system catalogs documentation > regarding pg_constraint.conisvalidated. So it does. Thanks I will rectify. -- Simon Riggs http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services