Horton

Re: index creation order?

Neil Conway <neilc@samurai.com>

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

-Neil