>> No. autovacuum is turned ON by default in 8.1 XP > Hrm, interesting that it's different than on Unix.
Why major functionality is configured differently in different platforms ? This increases the cost of initial tuning when mixed platforms are used. > Initial tuning != maintenance. Many of PostgreSQL's default settings are > extremely conservative and will benefit from being increased on almost > any hardware. There's extensive discussion of this to be found in the > pgsql-performance archives, but take a look at shared_buffers and > work_memory at a minimum. I need to create installation for dumb users to ship DBMS with my application. So manual initial tuning is not possible. How to force Postgres to use reliable settings by default? How to use shared_buffers=auto work_memory =auto in conf file ? Andrus. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
