Laszlo Nagy <[EMAIL PROTECTED]> writes:
> The process is still running:
Could you attach to it with gdb and see what it's doing?
>> Do you have a whole lot of tables in this database?
> One database has 140 tables, the other has 62. (There are two other
> database instances but they are rarely used.)
>> (Or even more directly: how large is $PGDATA/global/pgstat.stat ?)
>>
> -rw------- 1 pgsql pgsql 54536 Nov 3 20:11 pgstat.stat
Well, that lets out the theory that it just has a whole lot of stats
to keep track of ... although it's quite interesting that the file
timestamp isn't current. Somehow it's evidently gotten wedged in
a way that prevents it from updating the file.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
