Hi everyone, Have been putting together a tool called "pg_autotune" for automatically tuning a PostgreSQL database (either local or remote). It does this by repetitively benchmarking PostgreSQL (using Tatsuo's pgbench code) with different buffer settings, then fine tuning those settings depending on the results returned. All of the data generated is stored into a separate PostgreSQL database for further aggregate analysis later on.
This should be a default tool for all new PostgreSQL installations. The URL for pg_autotune is: http://gborg.postgresql.org/project/pgautotune It was created on a FreeBSD system, but should also work on at least Linux, Solaris, and MacOS X. This is a time & load intensive tool, so you'll need to ensure you only run it when you have a couple of hours to wait for the results. Overnight is good. :) Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
