Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id B3C332E002F for ; Thu, 5 Jun 2008 17:23:21 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04058-03 for ; Thu, 5 Jun 2008 17:23:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from crestone.coronasolutions.com (crestone.coronasolutions.com [66.45.104.24]) by developer.postgresql.org (Postfix) with ESMTP id 2627F2E002D for ; Thu, 5 Jun 2008 17:23:13 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by crestone.coronasolutions.com (Postfix) with ESMTP id BD0F5ACC1C6; Thu, 5 Jun 2008 13:22:50 -0600 (MDT) Received: from crestone.coronasolutions.com ([127.0.0.1]) by localhost (crestone.coronasolutions.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26842-04; Thu, 5 Jun 2008 13:22:50 -0600 (MDT) Received: from mac.local (dan-mac [10.1.250.4]) by crestone.coronasolutions.com (Postfix) with ESMTP id CD00AACC1B9 for ; Thu, 5 Jun 2008 13:22:49 -0600 (MDT) Message-ID: <48484B19.3060502@drivefaster.net> Date: Thu, 05 Jun 2008 14:22:49 -0600 From: Dan Harris User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: query performance question References: <4844F95B.4040009@m4n.nl> <31028.217.77.161.17.1212483874.squirrel@sq.gransy.com> <4848098A.5070500@drivefaster.net> <20080605171639.GE5624@it.is.rice.edu> In-Reply-To: <20080605171639.GE5624@it.is.rice.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at coronasolutions.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/36 X-Sequence-Number: 30386 Kenneth Marshall wrote: > Dan, > > Did you try this with 8.3 and its new HOT functionality? > > Ken > I did not. I had to come up with the solution before we were able to move to 8.3. But, Tom did mention that the HOT might help and I forgot about that when writing the prior message. I'm in the midst of moving 30 databases from 8.0 to 8.3 at the moment but when I'm finished, I might have time to test it. -Dan