X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E43D011F629F for ; Thu, 20 Apr 2006 18:20:06 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.122 X-Spam-Level: X-Spam-Status: No, score=0.122 required=5 tests=[AWL=0.122] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id r9w+LUDMVfnv for ; Thu, 20 Apr 2006 18:19:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 00BF311F662D for ; Thu, 20 Apr 2006 18:19:49 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3KLJmLf000106; Thu, 20 Apr 2006 17:19:48 -0400 (EDT) To: Brendan Duddridge cc: PostgreSQL Performance Subject: Re: Recovery will take 10 hours In-reply-to: <47C1F053-EC91-4AEB-9F0B-B538716145D6@clickspace.com> References: <85A15B2E-F59C-4FEF-82D4-61F48ABDCDE5@clickspace.com> <29439.1145564220@sss.pgh.pa.us> <47C1F053-EC91-4AEB-9F0B-B538716145D6@clickspace.com> Comments: In-reply-to Brendan Duddridge message dated "Thu, 20 Apr 2006 15:13:31 -0600" Date: Thu, 20 Apr 2006 17:19:48 -0400 Message-ID: <105.1145567988@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200604/473 X-Sequence-Number: 18557 Brendan Duddridge writes: > Do you mean do a kill -QUIT on the postgres process in order to > generate a stack trace? Not at all! I'm talking about tracing the kernel calls it's making. Depending on your platform, the tool for this is called strace, ktrace, truss, or maybe even just trace. With strace you'd do something like strace -p PID-of-process 2>outfile ... wait 30 sec or so ... control-C Not sure about the APIs for the others but they're probably roughly similar ... read the man page ... regards, tom lane