Hey all,
Iam using PostgreSQL 8.2.3 on RHEL4 (Linux 2.6.20.3-custom #4 SMP x86_64 x86_64
x86_64 GNU/Linux).
I have autovacuum tunrned off in the config, but it still seems to start up once
everyday. What could be the cause of this ?
TIA
Dushyanth
$ psql -U postgres
postgres=# show autovacuum
Hi,
Tom Lane sss.pgh.pa.us> writes:
> dushy gmail.com> writes:
> > On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver comcast.net>
wrote:
> >> One question? Did you do pg_ctl reload after changing the config file?
>
> > I did not change any config yet - autovacuum was always disabled since
> > th
Hey,
> Tom Lane sss.pgh.pa.us> writes:
> > Dushyanth gmail.com> writes:
> >> Does "show autovacuum" confirm that it's off?
>
> > Yes.
>
> > # show autovacuum;
> > autovacuum
> >
> > off
> > (1
Hi,
Tom Lane sss.pgh.pa.us> writes:
> Dushyanth gmail.com> writes:
> >> Tom Lane sss.pgh.pa.us> writes:
> >> Then the only other possibility is that autovacuum is being launched to
> >> prevent XID wraparound. Are there any tables in that database
699fbb
Let me know if you need anything else.
TIA
Dushyanth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
w what autovacuum is panicking about to warrant a force run.
Any pointers ?
TIA
Dushyanth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
