At 13:40 10/31/2003, Neil Conway wrote:
>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.
>
>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