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

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Having trouble with backups (was: Re: Crash Recovery)
Дата
Msg-id 20030125121710.F20026@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: Having trouble with backups (was: Re: Crash Recovery)  (Carlos Moreno <moreno@mochima.com>)
Список pgsql-performance
On Sat, Jan 25, 2003 at 10:22:51AM -0500, Carlos Moreno wrote:

> Well, it was a good thing that you brought it to my attention.
> Yes, two minutes after I wrote the message I found the docs
> that told me it is an SQL command -- which means that I'm
> positively sure that I'm not doing any of those  :-)  I guess

If you have a lot of foreign keys and are doing long-running UPDATES
(or other related things), I think you might also see the same thing.
You could spot this with ps -auxww (or friends) by looking for [some
db operation] waiting.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


В списке pgsql-performance по дате отправления:

Предыдущее
От: Carlos Moreno
Дата:
Сообщение: Re: Having trouble with backups (was: Re: Crash Recovery)
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: WEIRD CRASH?!?!