| From: | "Richard Huxton" <dev(at)archonet(dot)com> |
|---|---|
| To: | "Emmanuel Pierre" <epierre(at)apr-job(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgres load |
| Date: | 2001-02-20 16:51:54 |
| Message-ID: | 002101c09b5d$724d3460$1001a8c0@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
From: "Emmanuel Pierre" <epierre(at)apr-job(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paulo Parola | 2001-02-20 16:52:30 | unions on views (workaround?) |
| Previous Message | Barry Lind | 2001-02-20 16:50:09 | Re: win2000: problems starting postmaster |