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-06 07:33:29
Message-ID: 20070706093329.b0172600.adsmail@wars-nicht.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 4 Jul 2007 19:47:12 -0400 Alvaro Herrera wrote:

> Andreas 'ads' Scherbaum wrote:
>
> Oh. It's not the age. Please let us look at the pg_stat_user_tables
> entries for the involved tables? If it's picking the same tables maybe
> pgstats has stale info, but why is it not updating it?

Hmm, maybe because all the columns have '0' values ...

stats_row_level is on and stats_start_collector is on default (on).

Greetings from italy

--
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 Stefan Christ 2007-07-06 09:15:43 Day of week vs. Language
Previous Message PFC 2007-07-06 07:31:41 Re: Polymorphic delete help needed