Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C15869F99EB for ; Mon, 17 Sep 2007 21:38:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 80351-10 for ; Mon, 17 Sep 2007 21:38:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from tomts22-srv.bellnexxia.net (bc.sympatico.ca [209.226.175.184]) by postgresql.org (Postfix) with ESMTP id 613569F99E3 for ; Mon, 17 Sep 2007 21:38:23 -0300 (ADT) Received: from serenity ([70.52.75.201]) by tomts22-srv.bellnexxia.net (InterMail vM.5.01.06.13 201-253-122-130-113-20050324) with ESMTP id <20070918003821.YQXK18413.tomts22-srv.bellnexxia.net@serenity>; Mon, 17 Sep 2007 20:38:21 -0400 From: "Carlo Stonebanks" To: "'Merlin Moncure'" Cc: References: In-Reply-To: Subject: Re: Query works when kludged, but would prefer "best practice" solution Date: Mon, 17 Sep 2007 20:38:58 -0400 Message-ID: <4960312CC963437899EA96F416E8B032@serenity> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acf5iWE0n2ocsSdKT4a3xyRrOZ9mCgAAgfLQ X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/301 X-Sequence-Number: 26846 Thanks, it worked. Client happy. Big bonus in the mail. -----Original Message----- From: Merlin Moncure [mailto:mmoncure@gmail.com] Sent: September 17, 2007 8:18 PM To: Carlo Stonebanks Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Query works when kludged, but would prefer "best practice" solution On 9/17/07, Carlo Stonebanks wrote: > Well, there goes my dream of getting a recommendation that will deliver a > blinding insight into how to speed up all of my queries a thousand-fold. that's easy...delete your data! :-) merlin