On Wed, Nov 23, 2005 at 04:56:58PM +0200, Andrus wrote: > No. autovacuum is turned ON by default in 8.1 XP Hrm, interesting that it's different than on Unix. > I read from the docs you mentioned that Postgres has low maintenance needs > compared to other databases. So I'm expecting that there is no need to tune > something. 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. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
