Re: Open items - Mailing list pgsql-hackers

From Andrew Sullivan
Subject Re: Open items
Date
Msg-id 20031028151623.GH31003@libertyrms.info
Whole thread Raw
In response to Re: Open items  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Open items  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
On Tue, Oct 28, 2003 at 01:09:36AM -0500, Bruce Momjian wrote:
> I am grouping the above two items together --- I thought the idea was to
> give people a way to load 7.4 in a fairly rapid manner --- we now have
> the ability to do ALTER TABLE ADD CONSTRAINT, but it lacks ANALYZE
> statistics, so it is kind of slow --- perhaps nothing can be done about
> this.  Should we try to gather some statistics before doing the ALTER
> TABLE ADD CONSTRAINT queries if no stats exist?  I am not advocating it,
> but just asking.  Should COPY update the row count?  Would that help?

Maybe this is something to point out in the upgrading documents since
that way it seems it could be put off to the next release?  It sure
sounds like a feature, and one about which there still seems to be
fair disagreement.  It would indeed be nice, but it doesn't sound
like a show stopper to me if the proposal doesn't have anyone turning
up with the code to back it.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8                                        +1 416 646 3304
x110



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Open items
Next
From: Bruce Momjian
Date:
Subject: Re: Open items