| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Cc: | Gourish Singbal <gourish(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: auto vacuuming |
| Date: | 2006-03-31 18:50:37 |
| Message-ID: | 20060331185037.GF14204@surnet.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Jim C. Nasby wrote:
> 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.
IIRC in one of the original patches I had added a way to do it. It was
rejected however; it was argued that there was another mechanism to
disable it. I don't remember what it was though. The only possibility
that comes to mind is "ALTER DATABASE SET autovacuum TO off" but I don't
see why would it work.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2006-03-31 21:36:10 | Re: auto vacuuming |
| Previous Message | Jim C. Nasby | 2006-03-31 18:37:32 | Re: Bloated pg_shdepend_depender_index |