From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Allgood <jallgood@the-allgoods.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: High Load on Postgres 7.4.16 Server
Date: Fri, 06 Apr 2007 01:50:51 -0400
Message-ID: <28405.1175838651@sss.pgh.pa.us> (raw)
In-Reply-To: <009a01c777b5$7c683ae0$3da6d4c6@voyager>
References: <009a01c777b5$7c683ae0$3da6d4c6@voyager>
"John Allgood" <jallgood@the-allgoods.net> writes:
> ... The other configuration was RHEL3 and Postgres 7.4.13 and Redhat
> Cluster Suite. The application seemed to run much faster on the older
> equipment.
While I agree with the other comments that you should think about moving
to something newer than 7.4.x, there really shouldn't be any meaningful
performance difference between 7.4.13 and 7.4.16. I'm guessing some
sort of pedestrian pilot error, like not using similar postgresql.conf
settings or forgetting to ANALYZE the database after reloading it into
the new installation.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, jallgood@the-allgoods.net
Subject: Re: High Load on Postgres 7.4.16 Server
In-Reply-To: <28405.1175838651@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox