Re: index creation order?

From: Neil Conway <neilc(at)samurai(dot)com>
To: Allen Landsidel <all(at)biosys(dot)net>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: index creation order?
Date: 2003-10-31 18:40:22
Message-ID: 1067625622.451.0.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2003-10-31 18:45:48 Re: Pg+Linux swap use
Previous Message Allen Landsidel 2003-10-31 18:28:44 Re: index creation order?