Received: from serv1.ilse.nl (serv1.ilse.nl [212.189.131.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f25Leix45199 for ; Mon, 5 Mar 2001 16:40:44 -0500 (EST) (envelope-from mathijs@serv0.ilse.nl) Received: from serv0.ilse.nl (serv0.ilse.nl [212.189.131.10]) by serv1.ilse.nl (8.11.0/8.10.2) with ESMTP id f25LeaE36080; Mon, 5 Mar 2001 22:40:36 +0100 (MET) Received: (from mathijs@localhost) by serv0.ilse.nl (8.11.1/8.11.1) id f25LeUM23388; Mon, 5 Mar 2001 22:40:30 +0100 (CET) (envelope-from mathijs) Date: Mon, 5 Mar 2001 22:40:29 +0100 From: Mathijs Brands To: Bruce Momjian Cc: Justin Long , pgsql-sql@postgresql.org Subject: Re: Optimizing Query Message-ID: <20010305224029.A22983@ilse.nl> References: <5.0.2.1.0.20010305155556.00afb120@mail.strategicnetwork.org> <200103052107.QAA02196@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <200103052107.QAA02196@candle.pha.pa.us>; from pgman@candle.pha.pa.us on Mon, Mar 05, 2001 at 04:07:57PM -0500 X-Unexpected-Header: The Spanish Inquisition X-Archive-Number: 200103/68 X-Sequence-Number: 1713 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