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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Having trouble with backups (was: Re: Crash Recovery)
Дата
Msg-id 28204.1043457542@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Having trouble with backups (was: Re: Crash Recovery)  (Carlos Moreno <moreno@mochima.com>)
Ответы Re: Having trouble with backups (was: Re: Crash Recovery)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Mount options for Ext3?
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: WEIRD CRASH?!?!