Re: Optimizing Query - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Optimizing Query
Date
Msg-id 200103052145.QAA04808@candle.pha.pa.us
Whole thread Raw
In response to Re: Optimizing Query  (Mathijs Brands <mathijs@ilse.nl>)
Responses Re: Optimizing Query  (Justin Long <justinlong@strategicnetwork.org>)
Re: Optimizing Query  (Justin Long <justinlong@strategicnetwork.org>)
Re: Optimizing Query  (Justin Long <justinlong@strategicnetwork.org>)
Clustering (was Re: Optimizing Query)  (Mathijs Brands <mathijs@ilse.nl>)
List pgsql-sql
Yes.

> On Mon, Mar 05, 2001 at 04:07:57PM -0500, Bruce Momjian allegedly wrote:
> > Have you tried VACUUM ANALYZE and CLUSTER?
> 
> I assume CLUSTER still drops all indexes except the one you're clustering
> on?
> 
> Mathijs
> -- 
> It's not that perl programmers are idiots, it's that the language
> rewards idiotic behavior in a way that no other language or tool has
> ever done.
>                                                     Erik Naggum
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: Mathijs Brands
Date:
Subject: Re: Optimizing Query
Next
From: Bruce Momjian
Date:
Subject: Re: random