From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laszlo Nagy <gandalf@shopzeus.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: rebellious postgres process
Date: Tue, 04 Nov 2008 10:54:59 -0500
Message-ID: <18975.1225814099@sss.pgh.pa.us> (raw)
In-Reply-To: <49106CEE.7020204@shopzeus.com>
References: <490FFCF4.2050500@shopzeus.com>
<16117.1225804625@sss.pgh.pa.us>
<49106CEE.7020204@shopzeus.com>
Laszlo Nagy <gandalf@shopzeus.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, gandalf@shopzeus.com
Subject: Re: rebellious postgres process
In-Reply-To: <18975.1225814099@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox