Horton

Re: index creation order?

Allen Landsidel <all@biosys.net>

View thread View on postgr.es
From: Allen Landsidel <all@biosys.net>
To: Neil Conway <neilc@samurai.com>
Cc: Josh Berkus <josh@agliodbs.com>, PostgreSQL Performance <pgsql-performance@postgresql.org>
Date: 2003-10-31T19:01:28Z
Lists: pgsql-performance 
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