Re: pg_autovacuum

Adam Kavan wrote:

> At 09:41 PM 9/2/03 -0400, Matthew T. O'Connor wrote:
>>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
> Before updates:
>
> relname | n_tup_ins | n_tup_upd | n_tup_del
> ------------+-----------+-----------+-----------
> PointUsage | 0 | 0 | 0
> (1 row)
>
> After updates:
>
> relname | n_tup_ins | n_tup_upd | n_tup_del
> ------------+-----------+-----------+-----------
> PointUsage | 0 | 0 | 0
> (1 row)
>
> After deleting updates:
>
> relname | n_tup_ins | n_tup_upd | n_tup_del
> ------------+-----------+-----------+-----------
> PointUsage | 0 | 0 | 0
> (1 row)
>
> This is the problem... I just don't know how to fix it, or even what is
> causing it. I am 100% sure that I am inserting into the same database that
> I executed the select from. Here are the relevent lines from postgresql.conf:
>
> stats_start_collector = true
> #stats_command_string = true
> #stats_block_level = true
> stats_row_level = true
> stats_reset_on_server_start = false

And you restarted the postmaster since activating these non-standard
config options? Are you sure that *this* postgresql.conf file is what is
used by the database on startup?

Jan

>
> Any ideas?
>
> --- Adam Kavan
> --- akavan(at)cox(dot)net
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #