X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E89968B9EC1 for ; Wed, 23 Feb 2005 18:13:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87014-01 for ; Wed, 23 Feb 2005 18:12:55 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8C4478B9E18 for ; Wed, 23 Feb 2005 18:12:54 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j1NICrSu020648; Wed, 23 Feb 2005 13:12:53 -0500 (EST) To: "Cory Vokey" Cc: pgsql-admin@postgresql.org Subject: Re: Lingering Checkpoint Process In-reply-to: References: Comments: In-reply-to "Cory Vokey" message dated "Wed, 23 Feb 2005 11:28:25 -0500" Date: Wed, 23 Feb 2005 13:12:53 -0500 Message-ID: <20647.1109182373@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/264 X-Sequence-Number: 16432 "Cory Vokey" writes: > Hi all, I'm seeing a checkpoint process lingering around for ~ 24hrs on > one of my test systems and WAL logs are accumulating. It's running > postgres 7.4.6. Is the checkpoint process actually doing anything, or just sitting? (strace'ing it would reveal this) If it seems to be just sitting, could you attach to it with gdb and get a stack trace to find out where it's sitting? The only known cause of checkpoints not proceeding in 7.4.* is that long btree CREATE INDEX operations can block them. But 24 hours sounds pretty long for a CREATE INDEX too ... regards, tom lane