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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
