From: | "Joseph" <lters(at)mrtc(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: postgres load |
Date: | 2001-02-20 19:19:34 |
Message-ID: | CLEJKCMNOMBPKNIAIODGGEBOCAAA.lters@mrtc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I thought of using ReiserFS myself.
I wonder if that has anything to do with it.
Joseph
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Emmanuel Pierre
Sent: Tuesday, February 20, 2001 12:00 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] postgres load
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...
----
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.
I already do vacuum even on the fly ifever that can decrease
load, but
nothing...
I've done many indexed also...
Can someone help me ?
Emmanuel
--
EDENJOB / APR-Job
Email: epierre(at)apr-job(dot)com Home: www.apr-job.com
Phone: +33 1 47 81 02 41 Tatoo: +33 6 57 60 42 17
Fax: +33 1 41 92 91 54 eFAX: +44 0870-122-6748
******************************************************************
This message and any attachments (the "message") are confidential
and intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
E-mails are susceptible to alteration.
Neither EDENJOB/APR-JOB or affiliates shall be liable for the
message if altered, changed or falsified.
******************************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-02-20 19:26:07 | Re: vacuum analyze again... |
Previous Message | Tom Lane | 2001-02-20 19:17:51 | Re: vacuum analyze again... |