Hi!
On Mon, 13 Mar 2000 17:30:10 +0800
Brian Baquiran <[EMAIL PROTECTED]> wrote:
[snipped]
> I'm running postmaster with the options -B600 -N300. I'm using the RedHat RPMs
> >from a pretty-much-stock RH6.1 installation. Can I tune postgres to load more
> data into memory?
You should increase the buffer size. The number is counted in 8kB
pages, so a value of 600 gives 4MB of shared memory data buffer. With
1GB available, you can safely increase this parameter...
One other thing to speed up the backend is to use the -F option. But
this can result in data loss if the system crashes.
You should also increase the sort-buffer size (-S option for the
servers, not the postmaster).
HIH
&
HAND
Guido
--
"Please remain calm...I may be mad, but I am a professional."
-- Mad Scientist
