Re: Problem with autovacuum and pg_autovacuum

From: Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with autovacuum and pg_autovacuum
Date: 2007-07-09 01:19:18
Message-ID: 20070709031918.dd09c669.adsmail@wars-nicht.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 8 Jul 2007 19:12:46 -0400 Alvaro Herrera wrote:

> Oops :-( We should certainly make an effort to check the validity of
> the values in pg_autovacuum, but 0 is a perfectly valid value, so the
> check would not help you any in this case :-(

Apparently not, taken into account, that the 'enabled' column was set
to false. So the question remains, why autovacuum is not checking
this column first and then skip other calculations in the case, the table
is not activated at all.

Thinking more forward: would it make sense to have some kind of helper
in the database which gives (if enabled) notices back, if you are doing
something crazy? As example insert a value into a serial column (would
not be wrong and can be perfectly valid but for a beginner this could just
be a problem), maybe some helps from the planner about index usage or
missing index or in case of pg_autovacuum give some hints about
values which seem to create problems.

Kind regards

--
Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.
(Ferenc Mantfeld)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message lai yoke hman 2007-07-09 03:07:27 Direct I/O
Previous Message Alvaro Herrera 2007-07-09 01:10:55 Re: [GENERAL] Unable to get postgres running after long time no vacuum