Re: postgres load - Mailing list pgsql-general

From Richard Huxton
Subject Re: postgres load
Date
Msg-id 002101c09b5d$724d3460$1001a8c0@archonet.com
Whole thread Raw
In response to postgres load  (Emmanuel Pierre <epierre@apr-job.com>)
List pgsql-general
From: "Emmanuel Pierre" <epierre@apr-job.com>

> I republish my question for I had no answer, and this is a serious
> problem to me... I've used explain, vacuum, indexes... and so on, few
> nested requests...

Doesn't appear to be on the list.

>
> ----
> I am running PGSql 7.0.3 over Linux 2/ELF with a ReiserFS
> filesystem,
> Bi-P3 800 and 2Gb of RAM.
>
>         My database jump from 8 in load to 32 without any real reason
> nor too
> much requests.

There _will_ be a reason - what is top telling you?

>         I already do vacuum even on the fly ifever that can decrease
> load, but
> nothing...

Are you executing a particular query/set of queries when this happens? We'll
need more information I'm afraid.

- Richard Huxton



pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: Re: Installing DBI client
Next
From: Chris Jones
Date:
Subject: Re: vacuum analyze again...