On Fri, 2003-10-31 at 13:27, Allen Landsidel wrote: > I had no idea analyze was playing such a big role in this sense.. I really > thought that other than saving space, it wasn't doing much for tables that > don't have indexes on the.Advertising
ANALYZE doesn't save any space at all -- VACUUM is probably what you're thinking of.
Actually, I was thinking VACUUM ANALYZE.. which is what I ran after the COPY.. sorry for my lack of precision.
I've yet to run straight-up ANALYZE AFAIK.
-Allen
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
