Postgres Pro
Downloads
Home   >   mailing lists

Re: index creation order? - Mailing list pgsql-performance

From Neil Conway
Subject Re: index creation order?
Date
Msg-id 1067625622.451.0.camel@tokyo
Whole thread Raw
In response to Re: index creation order?  (Allen Landsidel <all@biosys.net>)
Responses Re: index creation order?  (Allen Landsidel <all@biosys.net>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Allen Landsidel
Date:
Subject: Re: index creation order?
Next
From: Neil Conway
Date:
Subject: Re: Pg+Linux swap use