Re: pg_autovacuum integration attempt #2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_autovacuum integration attempt #2
Date: 2004-07-17 15:38:23
Message-ID: 12874.1090078703@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

"Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
> What I wanted to do was have GUC prevent autovacuum = true
> when the stats collector is not enabled, reguardless of what is in
> postgresql.conf.

GUC can't do that, but I think you can just hack the boolean variable
during startup --- compare what pgstat.c does with
enable_stats_collector. (Not very clean, but I think it is okay within
the context of postmaster start.)

regards, tom lane

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Rod Taylor 2004-07-17 16:05:22 Re: pg_autovacuum integration attempt #2
Previous Message Bruce Momjian 2004-07-17 12:01:48 Re: pg_autovacuum integration attempt #2