Re: Having trouble with backups (was: Re: Crash Recovery) - Mailing list 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