Re: Open 7.4 items - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Open 7.4 items
Date
Msg-id 200310051334.h95DYsQ20221@candle.pha.pa.us
Whole thread Raw
In response to Re: Open 7.4 items  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> >> Improve speed of building of constraints during restore
> 
> > Did we get consensus on what to do with this,
> 
> Not really, it was still up in the air I thought.  However, the
> discussion will become moot if we don't have an implementation
> of the faster-checking alternative to look at pretty soon.  Do you
> have something nearly ready to show?

Last I remember, there was the idea to make ALTER TABLE use a query to
check all constraints at once, rather than per row, _and_ there was an
idea to turn it off by the superuser.  However, if we get the first one,
and it is fast, we might not even use the second one.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: Day of week question
Next
From: Bruce Momjian
Date:
Subject: Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized