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@apr-job.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.
******************************************************************
I thought of using ReiserFS myself.
I wonder if that has anything to do with it.
Joseph
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Emmanuel Pierre
Sent: Tuesday, February 20, 2001 12:00 PM
To: pgsql-general@postgresql.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@apr-job.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.
******************************************************************
On Wednesday 21 February 2001 01:19, Joseph wrote:
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...
Do not use ReiserFS on production machines. There are still enormous amount
of bugs includig data corruption, etc. See recent linux-kernel discussions
for details. That's why what you expiriencing is possible.
----
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
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------