Tom Lane wrote: > Jan Wieck <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend