Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id BEBF5632316 for ; Wed, 9 Jun 2010 08:35:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 53985-08 for ; Wed, 9 Jun 2010 11:35:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from 30.mail-out.ovh.net (30.mail-out.ovh.net [213.186.62.213]) by mail.postgresql.org (Postfix) with SMTP id 628DD6322ED for ; Wed, 9 Jun 2010 08:35:51 -0300 (ADT) Received: (qmail 2604 invoked by uid 503); 9 Jun 2010 11:29:04 -0000 Received: from b9.ovh.net (HELO mail632.ha.ovh.net) (213.186.33.59) by 30.mail-out.ovh.net with SMTP; 9 Jun 2010 11:29:04 -0000 Received: from b0.ovh.net (HELO queueout) (213.186.33.50) by b0.ovh.net with SMTP; 9 Jun 2010 13:35:49 +0200 Received: from par69-8-88-161-102-87.fbx.proxad.net (HELO apollo13) (lists%peufeu.com@88.161.102.87) by ns0.ovh.net with SMTP; 9 Jun 2010 13:35:48 +0200 Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes To: "Max Williams" , "'pgsql-performance@postgresql.org'" Subject: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? References: <0357196CB603794BB76F4F6B373F27330506EACE45@SERVER.ddnglobal.local> Date: Wed, 09 Jun 2010 13:35:42 +0200 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: "Pierre C" Message-ID: In-Reply-To: <0357196CB603794BB76F4F6B373F27330506EACE45@SERVER.ddnglobal.local> User-Agent: Opera Mail/10.10 (Linux) X-Ovh-Tracer-Id: 8976799957292484329 X-Ovh-Remote: 88.161.102.87 (par69-8-88-161-102-87.fbx.proxad.net) X-Ovh-Local: 213.186.33.20 (ns0.ovh.net) X-Spam-Check: DONE|U 0.5/N X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.794 tagged_above=-10 required=5 tests=BAYES_50=0.8, PLING_QUERY=0.994, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: * X-Archive-Number: 201006/137 X-Sequence-Number: 38993 Can you give the config params for those : fsync = synchronous_commit = wal_sync_method = Also, some "vmstat 1" output during the runs would be interesting.