Re: pg_autovacuum

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Adam Kavan <akavan(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_autovacuum
Date: 2003-09-03 01:41:40
Message-ID: 1062553300.5852.7.camel@zeutrh9
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jenny - 2003-09-03 01:57:41 Re: [HACKERS] identifying each individual tuple locked
Previous Message Martijn van Oosterhout 2003-09-03 01:23:17 Debian Woody 7.3.4 packages?