Thanks, it worked. Client happy. Big bonus in the mail. -----Original Message----- From: Merlin Moncure [mailto:mmoncure@xxxxxxxxx] Sent: September 17, 2007 8:18 PM To: Carlo Stonebanks Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Query works when kludged, but would prefer "best practice" solution On 9/17/07, Carlo Stonebanks <stonec.register@xxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings