Re: Large object loading stalls - Mailing list pgsql-general

From Tom Lane
Subject Re: Large object loading stalls
Date
Msg-id 7151.1234971725@sss.pgh.pa.us
Whole thread Raw
In response to Large object loading stalls  (Michael Akinde <michael.akinde@met.no>)
Responses Re: Large object loading stalls  (Michael Akinde <michael.akinde@met.no>)
Re: Large object loading stalls  (Michael Akinde <michael.akinde@met.no>)
List pgsql-general
Michael Akinde <michael.akinde@met.no> writes:
> We have been running into a strange problem on our production servers of
> a system we are about to roll out with the loading of large objects.

Hmm, can you attach to the stuck backend and the vacuum worker process
with gdb and get stack traces from them?  The pg_locks view does not
indicate any locking problem, but I'm wondering if there could be a
deadlock at the LWLock level.

            regards, tom lane

pgsql-general by date:

Previous
From: Martín Marqués
Date:
Subject: Mammoth replicator
Next
From: Martín Marqués
Date:
Subject: Mammoth replicator