Re: Problem with autovacuum and pg_autovacuum - Mailing list pgsql-general

From Andreas 'ads' Scherbaum
Subject Re: Problem with autovacuum and pg_autovacuum
Date
Msg-id 20070706093329.b0172600.adsmail@wars-nicht.de
Whole thread Raw
In response to Re: Problem with autovacuum and pg_autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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)

pgsql-general by date:

Previous
From: PFC
Date:
Subject: Re: Polymorphic delete help needed
Next
From: "Luki Rustianto"
Date:
Subject: DB crashed and duplicated template0 db