Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CD29F632822 for ; Fri, 16 Jul 2010 11:17:39 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 47018-05 for ; Fri, 16 Jul 2010 14:17:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from anastacia.gransy.com (anastacia.gransy.com [77.78.104.100]) by mail.postgresql.org (Postfix) with ESMTP id CD53C6327B5 for ; Fri, 16 Jul 2010 11:17:32 -0300 (ADT) Received: from sq.gransy.com (localhost [127.0.0.1]) by anastacia.gransy.com (Postfix) with ESMTP id 169F818E001; Fri, 16 Jul 2010 16:17:24 +0200 (CEST) Received: from 62.40.76.70 (proxying for unknown) (SquirrelMail authenticated user tv@fuzzy.cz) by sq.gransy.com with HTTP; Fri, 16 Jul 2010 16:17:24 +0200 (CEST) Message-ID: <59630.62.40.76.70.1279289844.squirrel@sq.gransy.com> In-Reply-To: References: <4C3EDB070200002500033621@gw.wicourts.gov> <1123546138.13276371279206773000.JavaMail.root@mm-mailstore02.merit.edu> Date: Fri, 16 Jul 2010 16:17:24 +0200 (CEST) Subject: Re: Identical query slower on 8.4 vs 8.3 From: tv@fuzzy.cz To: "Igor Neyman" Cc: "Patrick Donlin" , "Kevin Grittner" , pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.10a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-2 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201007/262 X-Sequence-Number: 39651 > I'd suggest to increase the value up to ~80MB, if not for the system, > may be just for the session running this query. > Then see if performance improved. Don't forget you can do this for the given query without affecting the other queries - just do something like SET work_mem = 128M and then run the query - it should work fine. This is great for testing and to set environment for special users (batch processes etc.). regards Tomas