Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UKE6I-00069T-S9 for pgsql-performance@arkaria.postgresql.org; Mon, 25 Mar 2013 20:34:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UKE6I-0002sm-Al for pgsql-performance@arkaria.postgresql.org; Mon, 25 Mar 2013 20:34:38 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UKE6H-0002sh-8A for pgsql-performance@postgresql.org; Mon, 25 Mar 2013 20:34:37 +0000 Received: from outmail148152.authsmtp.com ([62.13.148.152]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UKE6A-0004C6-Ho for pgsql-performance@postgresql.org; Mon, 25 Mar 2013 20:34:36 +0000 Received: from mail-c235.authsmtp.com (mail-c235.authsmtp.com [62.13.128.235]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id r2PKYTZN070855 for ; Mon, 25 Mar 2013 20:34:29 GMT Received: from [172.47.23.103] (70-36-143-10.dsl.dynamic.sonic.net [70.36.143.10]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/) with ESMTP id r2PKYPBm006656 for ; Mon, 25 Mar 2013 20:34:26 GMT Message-ID: <5150B4D0.3020902@agliodbs.com> Date: Mon, 25 Mar 2013 13:34:24 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130308 Thunderbird/17.0.4 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: 9.2.3 upgrade reduced pgbench performance by 60% References: <1CD2DD2A-C8C6-41CB-86CB-D44AE5E245CB@marketsworld.com> In-Reply-To: <1CD2DD2A-C8C6-41CB-86CB-D44AE5E245CB@marketsworld.com> X-Enigmail-Version: 1.5.1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: 62f6d108-958b-11e2-b5c5-002590a15da7 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkbIhBDJB8RWB5f NVxfJ1xYPXUEQkpF VCReGBUITgIzDi13 bhUsPEdCYEpPXBVo UEJKRlhQEktvAQIC AAAfVhpsdgVZen1v ZQggXBAgNSQIKEZ9 REhREyMHZWBnJmYd BkYMdgNcbQpPdk1Y a1EqVm5fZDYCe3pg RVJiZzloYDlWdzJv T1NFHmo/e2gsJBsJ D0FER3N0VVAdSD86 IxFuMFMQAU0cPg0q PlEsX1kYewcfEANZ BUREBiRUb1MQD3Rz QGsA X-Authentic-SMTP: 61633136333939.1023:706 X-AuthFastPath: 0 (Was 255) X-AuthSMTP-Origin: 70.36.143.10/23 X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org > The Linux server is on a cloud and has 4GB RAM and 2 CPUs and the > same server is running both master and slave (these are separate in > production). If you'd like any more details please ask. Here are the > pgbench results: Presumably you created a new cloud server for 9.2, yes? I'd guess that the difference is between the two cloud servers. Try testing, for example, bonnie++ on the two servers. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance