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 BAE3711F609E for ; Thu, 20 Apr 2006 22:15:59 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 required=5 tests=[none] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id n-j4RWymAW+5 for ; Thu, 20 Apr 2006 22:15:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from linuxworld.com.au (unknown [203.34.46.50]) by postgresql.org (Postfix) with ESMTP id 9A5A111F60B0 for ; Thu, 20 Apr 2006 22:15:54 -0300 (ADT) Received: from linuxworld.com.au (IDENT:swm@localhost.localdomain [127.0.0.1]) by linuxworld.com.au (8.13.2/8.13.2) with ESMTP id k3L1FU5G017126; Fri, 21 Apr 2006 11:15:31 +1000 Received: from localhost (swm@localhost) by linuxworld.com.au (8.13.2/8.13.2/Submit) with ESMTP id k3L1FS2R017123; Fri, 21 Apr 2006 11:15:29 +1000 X-Authentication-Warning: linuxworld.com.au: swm owned process doing -bs Date: Fri, 21 Apr 2006 11:15:28 +1000 (EST) From: Gavin Sherry X-X-Sender: swm@linuxworld.com.au To: Brendan Duddridge cc: Tomas Vondra , PostgreSQL Performance Subject: Re: Recovery will take 10 hours In-Reply-To: <5C372D71-D189-4AA7-A857-1C8FE42311AE@clickspace.com> Message-ID: References: <85A15B2E-F59C-4FEF-82D4-61F48ABDCDE5@clickspace.com> <29439.1145564220@sss.pgh.pa.us> <47C1F053-EC91-4AEB-9F0B-B538716145D6@clickspace.com> <105.1145567988@sss.pgh.pa.us> <53ACF10A-9240-420B-83AB-E4CBABD2AC56@clickspace.com> <44482CAF.70309@fuzzy.cz> <5C372D71-D189-4AA7-A857-1C8FE42311AE@clickspace.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200604/487 X-Sequence-Number: 18571 On Thu, 20 Apr 2006, Brendan Duddridge wrote: > Hi Tomas, > > Hmm... ktrace -p PID -c returns immediately without doing anything > unless I've previously done a ktrace -p PID. > > According to the man page for ktrace's -c flag: > -c Clear the trace points associated with the specified file > or processes. On other systems, strace/truss with -c produces a list of sys calls with the number of times they've been called in the elapsed period. To answer your other question, temporarily disabling fsync during the recovery should speed it up. For future reference, processing thousands of WAL files for recovery is not ideal. You should be doing a base backup much more often. Gavin