Re: Having trouble with backups (was: Re: Crash Recovery) - Mailing list pgsql-performance

From Tom Lane
Subject Re: Having trouble with backups (was: Re: Crash Recovery)
Date
Msg-id 28204.1043457542@sss.pgh.pa.us
Whole thread Raw
In response to Re: Having trouble with backups (was: Re: Crash Recovery)  (Carlos Moreno <moreno@mochima.com>)
Responses Re: Having trouble with backups (was: Re: Crash Recovery)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Carlos Moreno <moreno@mochima.com> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Mount options for Ext3?
Next
From: Rod Taylor
Date:
Subject: Re: WEIRD CRASH?!?!