From: "C. Bergström" <cbergstrom@netsyncro.com>
To: pgsql-performance@postgresql.org
Subject: Re: High Load on Postgres 7.4.16 Server
Date: Thu, 05 Apr 2007 22:28:23 +0300
Message-ID: <46154DD7.20402@netsyncro.com> (raw)
In-Reply-To: <009a01c777b5$7c683ae0$3da6d4c6@voyager>
References: <009a01c777b5$7c683ae0$3da6d4c6@voyager>
John Allgood wrote:
> Hello All
>
> I sent this message to the admin list and it never got through so I
> am trying the performance list.
> We moved our application to a new machine last night. It is a Dell
> PowerEdge 6950 2X Dual Core. AMD Opteron 8214 2.2Ghz. 8GB Memory. The
> machine is running Redhat AS 4 Upd 4 and Redhat Cluster Suite. The SAN is an
> EMC SAS connected via fibre. We are using Postgres 7.4.16. We have recently
> had some major hardware issues and replaced the hardware with brand new Dell
> equipment. We expected a major performance increase over the previous being
> the old equipment was nearly three years old
> I will try and explain how things are configured. We have 10
> separate postmasters running 5 on each node. Each of the postmasters is a
> single instance of each database. Each database is separated by division and
> also we have them separate so we can restart an postmaster with needing to
> restart all databases My largest database is about 7 GB. And the others run
> anywhere from 100MB - 1.8GB.
> 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.
> My thoughts on the issues are that I could be something with the OS
> tuning. Here is what my kernel.shmmax, kernel.shmall = 1073741824. Is there
> something else that I could tune in the OS. My max_connections=35 and shared
> buffers=8192 for my largest database.
>
Update to 8.x.x at least
C.
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: cbergstrom@netsyncro.com
Subject: Re: High Load on Postgres 7.4.16 Server
In-Reply-To: <46154DD7.20402@netsyncro.com>
* 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