Re: pg_autovacuum - Mailing list pgsql-general

From Matthew T. O'Connor
Subject Re: pg_autovacuum
Date
Msg-id 1062553300.5852.7.camel@zeutrh9
Whole thread Raw
In response to Re: pg_autovacuum  (Adam Kavan <akavan@cox.net>)
Responses Re: pg_autovacuum  (Adam Kavan <akavan@cox.net>)
List pgsql-general
On Tue, 2003-09-02 at 20:40, Adam Kavan wrote:
> And there is the problem, all of the counts stay at 0 no matter what I do.

OK, so why is this happening... a bug in the stats system?  Ignoring
pg_autovaccu, what numbers do you get from the stats system when you do
a:

SELECT relname,n_tup_ins,n_tup_upd,n_tup_del from pg_stat_user_tables
where relname = 'foobar';

both before and after your insert / update script.

Matthew


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Debian Woody 7.3.4 packages?
Next
From: "Jenny -"
Date:
Subject: Re: [HACKERS] identifying each individual tuple locked