Re: Stats collector frozen?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeremy Haile" <jhaile(at)fastmail(dot)fm>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Stats collector frozen?
Date: 2007-01-24 19:00:52
Message-ID: 3975.1169665252@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jeremy Haile" <jhaile(at)fastmail(dot)fm> writes:
> The stats collector appears to still be running, since I can see a
> postgres.exe process with -forkcol. However, I never notice it using
> I/O or CPU usage. Also, querying the pg_stat_user_tables view shows no
> change in table stats even for tables that change very frequently.

Is $PGDATA/global/pgstat.stat getting updated? (watch the file mod time
at least) Do you see any pgstat.tmp file in there?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message guillermo arias 2007-01-24 19:06:25 capacity of tables
Previous Message Rich Shepard 2007-01-24 18:57:27 Cannot Restart PostgreSQL-8.1.4