Thread
-
Re: postgres load
Richard Huxton <dev@archonet.com> — 2001-02-20T16:51:54Z
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
-
postgres load
Emmanuel Pierre <epierre@apr-job.com> — 2001-02-20T16:59:58Z
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. ****************************************************************** -
RE: postgres load
Joseph <lters@mrtc.com> — 2001-02-20T19:19:34Z
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. ****************************************************************** -
Re: postgres load
Denis Perchine <dyp@perchine.com> — 2001-02-21T08:47:51Z
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 ----------------------------------