From: Richard Huxton <dev@archonet.com>
To: James Dey <james@mygus.com>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Basic Database Performance
Date: Fri, 10 Feb 2006 09:50:21 +0000
Message-ID: <43EC61DD.8010106@archonet.com> (raw)
In-Reply-To: <20060210094413.7690943ED@ctb-mesg4.saix.net>
References: <20060210094413.7690943ED@ctb-mesg4.saix.net>
Don't forget to cc: the list.
James Dey wrote:
> Hi Richard,
>
> Firstly, thanks a million for the reply.
>
> To answer your questions:
> 1. Are you limited by CPU, memory or disk i/o?
> I am not limited, but would like to get the most out of the config I have in
> order to be able to know what I'll get, when I scale up.
But you said: "During the day, the system is incredibly slow to a point
where it is unusable". So presumably one or more of cpu,memory or disk
i/o is the problem.
> 2. Are you happy your config settings are good? How do you know?
> I'm not, and would appreciate any help with these.
If you have a look here, there is an introduction for 7.4
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
For 8.x you might find the following more useful.
http://www.powerpostgresql.com/PerfList> 3. Are there particular queries that are causing the problem, or lock
> contention?
> Not that I can see
What is the balance between activity on Apache/PHP/PostgreSQL?
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, james@mygus.com
Subject: Re: Basic Database Performance
In-Reply-To: <43EC61DD.8010106@archonet.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