Re: auto vacuuming
От
Jim C. Nasby
Тема
Re: auto vacuuming
Дата
Msg-id
20060331174802.GS49405@pervasive.com
Ответ на
auto vacuuming (Gourish Singbal)
Список
Дерево обсуждения
auto vacuuming "Gourish Singbal" <gourish@gmail.com>
Re: auto vacuuming "Jim C. Nasby" <jnasby@pervasive.com>
Re: auto vacuuming Alvaro Herrera <alvherre@commandprompt.com>
Re: auto vacuuming "Matthew T. O'Connor" <matthew@zeut.net>
Re: auto vacuuming "Jim C. Nasby" <jnasby@pervasive.com>
Re: auto vacuuming "Matthew T. O'Connor" <matthew@zeut.net>
Re: auto vacuuming Jim Nasby <jnasby@pervasive.com>
Re: auto vacuuming Tom Lane <tgl@sss.pgh.pa.us>
Re: auto vacuuming Jim Nasby <jnasby@pervasive.com>
Re: auto vacuuming Tom Lane <tgl@sss.pgh.pa.us>
Re: auto vacuuming Tom Lane <tgl@sss.pgh.pa.us>
Re: auto vacuuming Alvaro Herrera <alvherre@commandprompt.com>
Re: auto vacuuming Tom Lane <tgl@sss.pgh.pa.us>
Re: auto vacuuming John DeSoi <desoi@pgedit.com>
Re: auto vacuuming Tom Lane <tgl@sss.pgh.pa.us>
Re: auto vacuuming "Joshua D. Drake" <jd@commandprompt.com>
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@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
В списке pgsql-admin по дате отправления
