Re: Open 7.4 items - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Open 7.4 items
Date
Msg-id 200310061826.h96IQOO10578@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:
> Jan Wieck <JanWieck@Yahoo.com> writes:
> > Does an ANALYZE run between index creation and bulk FK checking improve 
> > planning?
> 
> It almost certainly would, but I was assuming we had to consider this in
> the context of loading existing dump files.  We could think about having
> pg_dump emit an automatic ANALYZE after the data loading step in the
> future though.

I don't have a problem with having it be slower for 7.4 upgrades if we
can make it reasonable for future loads.

--  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: "monu_indian"
Date:
Subject: index changing
Next
From: Peter Eisentraut
Date:
Subject: Re: db encoding