| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Lonni J Friedman <netllama(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: upgrade from 9.2.x to 9.3 causes significant performance degradation |
| Date: | 2013-09-17 22:47:26 |
| Message-ID: | 20130917224726.GA29545@awork2.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Tanzer | 2013-09-17 22:48:47 | Re: Why does this array query fail? |
| Previous Message | David Johnston | 2013-09-17 22:05:09 | Re: Why does this array query fail? |