Re: Why pgAdmin III guru suggests VACUUM in 8.1

>> 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.