You'll probably want to take a look at this performance tuning
reference:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
and this annotated configuration file:
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Apr 17, 2005, at 4:57 AM, Dino Vliet wrote:
> OK,
> I have RTFM:-)
> SHMALL Total amount of shared memory available (bytes
> or pages) if bytes, same as SHMMAX; if pages,
> ceil(SHMMAX/PAGE_SIZE)
>
> These values should be the same. I've changed that
> now.
>
> Still my second question is valid though. Are there
> any other values I should consider changing in order
> to boost performance.
> I'm using postgresql 7.4.
>
> Brgds
> Dino