| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | Sriram Dandapani <sdandapani(at)counterpane(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: autovacuum ignore tables |
| Date: | 2006-09-19 04:10:26 |
| Message-ID: | 450F6DB2.5060908@zeut.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Sriram Dandapani wrote:
>
> Hi
>
>
>
> Is it possible to tell autovacuum to ignore certain tables (These
> tables are high traffic daily partition tables that get dropped every
> other day).
>
>
>
> I am trying to get autovacuum to complete quicker and prevent Xactn
> wraparound (currently, it takes very long and due to the fact that I
> have to restart the database for maintenance purposes), autovacuum
> never finishes.)
>
If you are running PostgreSQL 8.1 with integrated autovacuum, then yes,
you can disable autovacuum on a per table basis, if you are using an
older version with the contrib autovacuum, then no.
Matt
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josef Springer | 2006-09-19 06:36:47 | Installing Postgres 8.1 as a service pn Windows only |
| Previous Message | Matthew T. O'Connor | 2006-09-19 04:08:14 | Re: When vaccuum full should be performed with postgresql-8.1 |