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@cox.net
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.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@Yahoo.com #