Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group