X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6F663D1CCB9 for ; Fri, 5 Mar 2004 16:29:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 85808-09 for ; Fri, 5 Mar 2004 12:29:00 -0400 (AST) Received: from dervish.jonathangardner.net (dervish.jonathangardner.net [66.92.192.241]) by svr1.postgresql.org (Postfix) with ESMTP id 190D3D1C914 for ; Fri, 5 Mar 2004 12:28:57 -0400 (AST) Received: from atlas.jonathangardner.net (atlas.jonathangardner.net [66.92.192.166]) (authenticated bits=0) by dervish.jonathangardner.net (8.12.10/8.12.10) with ESMTP id i25GStxJ032481 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Fri, 5 Mar 2004 08:28:56 -0800 From: "Jonathan M. Gardner" To: Charles Hauser Subject: Re: query optimization Date: Fri, 5 Mar 2004 08:28:42 -0800 User-Agent: KMail/1.6 Cc: pgsql-sql@postgresql.org References: <1078422984.5001.18.camel@pandorina> In-Reply-To: <1078422984.5001.18.camel@pandorina> MIME-Version: 1.0 Content-Disposition: inline Content-Type: Text/Plain; charset="windows-1252" Content-Transfer-Encoding: quoted-printable Message-Id: <200403050828.45937.jgardner@jonathangardner.net> Received-SPF: pass (dervish.jonathangardner.net: sender at 66.92.192.166 was authenticated) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/44 X-Sequence-Number: 17143 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday 04 March 2004 9:56 am, Charles Hauser wrote: > All, > > I have the following query which is running quite slow on our server > and was hoping someone would have suggestions how I might improve it. > Might want to try emailing the performance list as well, after you take=20 Tom's advice. They tend to get more excited about performance issues. - --=20 Jonathan Gardner jgardner@jonathangardner.net -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFASKq6qp6r/MVGlwwRAjeiAKCJpD/imnxP71f1GU8zpUVrWvd+qACeNcOF 9KvCM7HSp7jr9Ep9Xrs050M=3D =3DPh6a -----END PGP SIGNATURE-----