Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group