Tuning PostgreSQL to use more RAM...

From: "Steve Wolfe" <steve(at)iboats(dot)com>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Tuning PostgreSQL to use more RAM...
Date: 2000-08-15 16:47:57
Message-ID: 00ab01c006d8$96e58260$85755ad1@iboats.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Actually, more RAM would permit you to increase both the -B parameters as
> well as the -S one ... which are both noted for providing performance
> increases ... -B more on repeative queries and -S on anything involving
> ORDER BY or GROUP BY ...

For a while now, I've been meaning to investigate how to get PostgreSQL to
take advantage of the RAM in our machine. It has 512 megs, and most of the
time, about 275-400 megs of it simply go to disk cache & buffer, as nothing
else wants it. Occasionally, we'll only have 250-300 megs of disk cache.
: )

While I don't mind disk cache, I feel that we could get better
performance by letting postgres use another hundred megs or so, especially
since our entire /usr/local/pgsql/base directory has only 134 megs of data.
We're currently starting the postmaster with "-B 2048". The machine has 4
Xeon processors, and 5 drives in the RAID array, so we do have a small bit
of CPU power and disk throughput. Any suggestions or pointers are welcome.

steve

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2000-08-15 16:56:04 Re: Open Source Database Routs Competition in New Benchmark Tests
Previous Message Ross J. Reedstrom 2000-08-15 16:45:51 Re: Great Bridge benchmark results for Postgres, 4 others