On Wed, Oct 07, 2009 at 11:12:27AM +0800, Lawrence Giam wrote:
> Hi All,
>  
> I was reading in the Slony 1.2.16 documentation on maintenance section
> 6.1 - Interaction with PostgreSQL autovacuum. In the documentation,
> there is this query which was recommended to execute in order to exclude
> some slony tables from being run by the Postgres autovacuum features. I
> am running Postgres 8.1.7 on Debian Etch.

I completely forget how the autovacuum tables on 8.1.x work, but I
think you want to have a careful look at its documentation.
Autovacuum in 8.1 was, IIRC, significantly different from later
versions and ISTR that it was the wrong choice for certain kinds of
workloads.  The change you need is _something_ like what you're
suggesting, but I wouldn't recommend it without a fairly clear
understanding of the autovacuum issues in 8.1.

(On another note, one of the problems with the Debian release model is
that it inevitably results in very old major Postgres releases.  I'd
counsel looking into a backport, because Postgres has advanced a lot
past 8.1, if you ask me.)

A



-- 
Andrew Sullivan
ajs at crankycanuck.ca