| From: | Bernd Helmle <mailings(at)oopsware(dot)de> |
|---|---|
| To: | Simon Riggs <simon(at)2ndQuadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Cc: | pgsql-committers(at)postgresql(dot)org |
| Subject: | Re: pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini |
| Date: | 2011-02-08 21:58:38 |
| Message-ID: | 6A719D1DE382A36D92E56C7A@amenophis |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
--On 8. Februar 2011 12:24:11 +0000 Simon Riggs <simon(at)2ndQuadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2011-02-08 23:00:03 | Re: [COMMITTERS] pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini |
| Previous Message | Tom Lane | 2011-02-08 21:23:01 | pgsql: Core support for "extensions", which are packages of SQL objects |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2011-02-08 22:03:14 | Re: Extensions support for pg_dump, patch v27 |
| Previous Message | Tom Lane | 2011-02-08 21:54:45 | Re: Extensions versus pg_upgrade |