Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D597764FEF7 for ; Tue, 4 Nov 2008 11:55:03 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 38305-01 for ; Tue, 4 Nov 2008 11:55:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 197F964FEC3 for ; Tue, 4 Nov 2008 11:55:01 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id mA4FsxU4018976; Tue, 4 Nov 2008 10:54:59 -0500 (EST) To: Laszlo Nagy cc: pgsql-admin@postgresql.org Subject: Re: rebellious postgres process In-reply-to: <49106CEE.7020204@shopzeus.com> References: <490FFCF4.2050500@shopzeus.com> <16117.1225804625@sss.pgh.pa.us> <49106CEE.7020204@shopzeus.com> Comments: In-reply-to Laszlo Nagy message dated "Tue, 04 Nov 2008 16:40:30 +0100" Date: Tue, 04 Nov 2008 10:54:59 -0500 Message-ID: <18975.1225814099@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200811/25 X-Sequence-Number: 30679 Laszlo Nagy 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