Re: Basic Database Performance

From: Richard Huxton <dev(at)archonet(dot)com>
To: James Dey <james(at)mygus(dot)com>
Cc: 'Postgresql Performance' <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Basic Database Performance
Date: 2006-02-10 09:50:21
Message-ID: 43EC61DD.8010106@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message James Dey 2006-02-10 09:55:49 Re: Basic Database Performance
Previous Message Richard Huxton 2006-02-10 09:36:35 Re: Basic Database Performance