X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 83C3CD1C91F for ; Fri, 8 Aug 2003 17:46:12 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 62437-06 for ; Fri, 8 Aug 2003 14:44:44 -0300 (ADT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id AB8F5D1C4DB for ; Fri, 8 Aug 2003 14:46:00 -0300 (ADT) Received: from mailgw1.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id ADD972BD49; Fri, 8 Aug 2003 19:45:54 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by mailgw1.ucs.co.za (Postfix) with ESMTP id CFCB6DA299; Fri, 8 Aug 2003 19:45:54 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id 04B989737E; Fri, 8 Aug 2003 19:45:51 +0200 (SAST) Date: Fri, 8 Aug 2003 19:45:50 +0200 From: Stef To: Jonathan Gardner Cc: pgsql-sql@postgresql.org Subject: Re: Analyze makes queries slow... Message-Id: <20030808194550.3eb9cde0.svb@ucs.co.za> In-Reply-To: <200308080924.50218.jgardner@jonathangardner.net> References: <20030806171855.6c9ebf4d.svb@ucs.co.za> <200308080924.50218.jgardner@jonathangardner.net> X-Mailer: Sylpheed version 0.9.4claws (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: LV^-*d3kQlL,6{Y:X)M~tuL#y!p.kO_Qbc!xxqhZC4s}Y]L0g)z^aiLsQGY34d|}Xp:HNm)MRsc?^?ZQ}smznF&jx|w@,a**K&QL.Dc~2~M5V`zb>hExCJDB[[o=M)e"; k-n[7tz2TY7+; *_xX's(5cUEtdw*yG-OmKm}6($zpUz8S`Nz@w X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/77 X-Sequence-Number: 14693 On Fri, 8 Aug 2003 09:24:48 -0700 Jonathan Gardner wrote: => Try the performance list. Thanks for the tip Stef