Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D5D57475F1A for ; Fri, 24 Jan 2003 20:19:01 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 2780C475D17 for ; Fri, 24 Jan 2003 20:19:01 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0P1J35u028205; Fri, 24 Jan 2003 20:19:03 -0500 (EST) To: Carlos Moreno Cc: PgSQL Performance ML Subject: Re: Having trouble with backups (was: Re: Crash Recovery) In-reply-to: <3E31DA80.7000000@mochima.com> 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> Comments: In-reply-to Carlos Moreno message dated "Fri, 24 Jan 2003 19:29:52 -0500" Date: Fri, 24 Jan 2003 20:19:02 -0500 Message-ID: <28204.1043457542@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/314 X-Sequence-Number: 961 Carlos Moreno writes: > Tom Lane wrote: >> Other people have responded on the assumption that this is a performance >> problem, but you should also consider the possibility that it's bad >> coding of your application software. Does your app try to grab >> exclusive table locks? > One quick question, Tom, before some general comments and > reply to the other messages... Where would I specify any > locks the software wants to do? If you are not issuing any explicit "LOCK" SQL commands, then you can disregard my theory. regards, tom lane