> Although I suggested doing a single unconditional ANALYZE at the end > of the script, second thought leads me to think the per-table ANALYZE > (probably issued right after the table's data-load step) might be > better. That way you'd not have any side-effects on already-existing > tables in the database you are loading to. OTOH, that way would leave > the system catalogs un-analyzed, which might be bad.
How about adding an ANALYZE SCHEMA pg_catalog; option :) Chris ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org