"Jeremy Haile" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
