Howard Cole wrote:
Hi,
I have not been able to use the tuning wizard in windows for
postgresql 8.4 since it stops postgres starting so I have been looking
to tweak the postgresql.conf file directly. I am happy with the
performance of postgres in general but I feel that it is not utilising
the memory on my servers to its full potential so I am looking for
some tweaks to get it turbo-charged.
There seems to be little documentation on tuning these settings for a
Windows based machine and many of the performance tuning notes I have
found seem not to apply for version 8.4. One example of this is the
maintenance_work_mem which now runs out of memory if I set it to
values that I used for previous postgres builds (512MB).
I have lots of unutilised RAM on my system, and so I try and increase
the shared_buffers on my server to 2GB, however postgres will not
start when the value is set this high, so at the moment it is set to
512MB. Are there any optimal settings for this on windows.
The third value I am experimenting with is work_mem, which at present
is set to 12MB - but memory still appears to be unused. I have a test
system with 3.5GB which rarely appears to go over 1GB and a production
server with 8GB which barely touches the RAM.
I would really appreciate anyone pointing me in the right direction
with regards tuning an 8.4 based windows machine.
Thanks.
I withdraw these comments. I've just found an excellent article here :
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
Which covers most things I need. I tend to avoid anything with WIKI in
the title because it tends to be incomplete rubbish but the article by
Greg Smith etc is excellent and has lots of detail for 8.4/Windows.
Ta
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
