Re: Having trouble with backups (was: Re: Crash Recovery)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carlos Moreno <moreno(at)mochima(dot)com>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Having trouble with backups (was: Re: Crash Recovery)
Date: 2003-01-25 01:19:02
Message-ID: 28204.1043457542@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Carlos Moreno <moreno(at)mochima(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2003-01-25 01:20:11 Re: WEIRD CRASH?!?!
Previous Message Tom Lane 2003-01-25 01:16:48 Re: Mount options for Ext3?