Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UUKkT-0005tq-Be for pgsql-performance@arkaria.postgresql.org; Mon, 22 Apr 2013 17:41:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UUKkS-0001zl-Sp for pgsql-performance@arkaria.postgresql.org; Mon, 22 Apr 2013 17:41:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UUKkR-0001yl-DB for pgsql-performance@postgresql.org; Mon, 22 Apr 2013 17:41:51 +0000 Received: from smtp-outbound-1.vmware.com ([208.91.2.12]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UUKkN-0006W4-Ck for pgsql-performance@postgresql.org; Mon, 22 Apr 2013 17:41:50 +0000 Received: from sc9-mailhost3.vmware.com (sc9-mailhost3.vmware.com [10.113.161.73]) by smtp-outbound-1.vmware.com (Postfix) with ESMTP id 24FA82810E; Mon, 22 Apr 2013 10:41:43 -0700 (PDT) Received: from zcs-prod-ext-mta-1.vmware.com (zcs-prod-ext-mta-1.vmware.com [10.113.62.223]) by sc9-mailhost3.vmware.com (Postfix) with ESMTP id 1F6914013C; Mon, 22 Apr 2013 10:41:43 -0700 (PDT) Received: from localhost (localhost.localdomain [127.0.0.1]) by zcs-prod-ext-mta-1.vmware.com (Postfix) with ESMTP id B85E9120044; Mon, 22 Apr 2013 10:46:22 -0700 (PDT) X-Virus-Scanned: amavisd-new at zcs-prod-ext-mta-1.vmware.com Received: from zcs-prod-ext-mta-1.vmware.com ([127.0.0.1]) by localhost (zcs-prod-ext-mta-1.vmware.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ZhuioH1MzyrM; Mon, 22 Apr 2013 10:46:22 -0700 (PDT) Received: from zcs-prod-ext-mta-1.vmware.com (localhost.localdomain [127.0.0.1]) by zcs-prod-ext-mta-1.vmware.com (Postfix) with ESMTP id 8B328120043; Mon, 22 Apr 2013 10:46:22 -0700 (PDT) Received: from [192.168.1.90] (zimbra-prod-ext-proxy-vip.vmware.com [10.113.63.87]) by zcs-prod-ext-mta-1.vmware.com (Postfix) with ESMTPSA; Mon, 22 Apr 2013 10:46:21 -0700 (PDT) Message-ID: <51757655.3030101@vmware.com> Date: Mon, 22 Apr 2013 20:41:41 +0300 From: Heikki Linnakangas Organization: VMware User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.12) Gecko/20130116 Icedove/10.0.12 MIME-Version: 1.0 To: Anne Rosset CC: "pgsql-performance@postgresql.org" Subject: Re: Performance with the new security release References: <9A6B86D66BD3C2438AFACFA09354890F20A2A781@EXCH01.sp.corp.collab.net> In-Reply-To: <9A6B86D66BD3C2438AFACFA09354890F20A2A781@EXCH01.sp.corp.collab.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -6.9 (------) 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 On 22.04.2013 19:48, Anne Rosset wrote: > Hi, > We are seeing some overall performance degradation in our application since we installed the security release. Other commits were also done at the same time in the application so we don't know yet if the degradation has any relationship with the security release. > While we are digging into this, I would like to know if it is possible that the release has some impact on performance. After reading this "It was created as a side effect of a refactoring effort to make establishing new connections to a PostgreSQL server faster, and the associated code more maintainable.", I am thinking it is quite possible. I doubt that particular commit, the one that fixed the security issue, could cause any meaningful slowdown. But it's not impossible that some other fix included in the release would cause a regression, although we try to be careful to avoid that. If you narrow the culprit down to the new PostgreSQL version, we're going to need more details to find the root cause. - Heikki -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance