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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: 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