RE: postgres load - Mailing list pgsql-general

From Joseph
Subject RE: postgres load
Date
Msg-id CLEJKCMNOMBPKNIAIODGGEBOCAAA.lters@mrtc.com
Whole thread Raw
In response to postgres load  (Emmanuel Pierre <epierre@apr-job.com>)
Responses Re: postgres load  (Denis Perchine <dyp@perchine.com>)
List 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@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.

******************************************************************


pgsql-general by date:

Previous
From: Dan Lyke
Date:
Subject: Re: Re: A How-To: PostgreSQL from Tcl via ODBC
Next
From: Bruce Momjian
Date:
Subject: Re: vacuum analyze again...