Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E7FF9475BF9 for ; Sat, 25 Jan 2003 12:17:05 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 3266A475AD4 for ; Sat, 25 Jan 2003 12:17:05 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18cTva-0005Z4-00 for ; Sat, 25 Jan 2003 12:17:10 -0500 Date: Sat, 25 Jan 2003 12:17:10 -0500 From: Andrew Sullivan To: PgSQL Performance ML Subject: Re: Having trouble with backups (was: Re: Crash Recovery) Message-ID: <20030125121710.F20026@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , PgSQL Performance ML References: <2147483647.1043361178@[10.0.1.133]> <1043416377.29437.70.camel@haggis> <3E3158DA.7080807@mochima.com> <22650.1043442101@sss.pgh.pa.us> <3E31DA80.7000000@mochima.com> <28204.1043457542@sss.pgh.pa.us> <28260.1043458181@sss.pgh.pa.us> <3E32ABCB.6070003@mochima.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3E32ABCB.6070003@mochima.com>; from moreno@mochima.com on Sat, Jan 25, 2003 at 10:22:51AM -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/329 X-Sequence-Number: 976 On Sat, Jan 25, 2003 at 10:22:51AM -0500, Carlos Moreno wrote: > Well, it was a good thing that you brought it to my attention. > Yes, two minutes after I wrote the message I found the docs > that told me it is an SQL command -- which means that I'm > positively sure that I'm not doing any of those :-) I guess If you have a lot of foreign keys and are doing long-running UPDATES (or other related things), I think you might also see the same thing. You could spot this with ps -auxww (or friends) by looking for [some db operation] waiting. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110