Postgres Pro
Downloads
Home   >   mailing lists

Re: upgrade from 9.2.x to 9.3 causes significant performance degradation - Mailing list pgsql-general

From Andres Freund
Subject Re: upgrade from 9.2.x to 9.3 causes significant performance degradation
Date
Msg-id 20130917224726.GA29545@awork2.anarazel.de
Whole thread Raw
In response to upgrade from 9.2.x to 9.3 causes significant performance degradation  (Lonni J Friedman <netllama@gmail.com>)
Responses Re: upgrade from 9.2.x to 9.3 causes significant performance degradation  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
Tree view 
Hi,

On 2013-09-17 09:19:29 -0700, Lonni J Friedman wrote:
> I'm running a PostgreSQL 9.3.0 cluster (1 master with two streaming
> replication hot standby slaves) on RHEL6-x86_64.  Yesterday I upgraded
> from 9.2.4 to 9.3.0, and since the upgrade I'm seeing a significant
> performance degradation.  PostgreSQL simply feels slower.  Nothing
> other than the version of PostgreSQL changed yesterday.  I used
> pg_upgrade to perform the upgrade, and ran the generated
> analyze_new_cluster.sh immediately afterwards, which completed
> successfully.

Where did you get 9.3.0 from? Compiled it yourself? Any chance you
compile with --enable-cassert or somesuch?

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Why does this array query fail?
Next
From: Lonni J Friedman
Date:
Subject: Re: upgrade from 9.2.x to 9.3 causes significant performance degradation