On Wed, Mar 29, 2006 at 03:36:36PM +0530, Gourish Singbal wrote: > we are using postgresql 8.1.3 and wanted to enable autovacuuming for only > one of the many databases on the same postgresql cluster. > pg_autovacuum seems to allow to ignore only a particular table and not the > database since column vacrelid is OID from pg_class table Are there any > suggestions to accomplish this tasks?. Currently there is no way to exclude entire databases from autovacuum. I'm curious, why do you want to do this anyway? -- 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
