Hannu Krosing <hannu(at)tm(dot)ee> writes:
> I could send you tails of postgres logfiles that are rotated on
> detecting
> the INSERT/UPDATE wait condition that does not go away in 10 sec.
> How long logfiles (time) would be enough ?
Do the logs show the queries being executed? The queries forming
the current transaction of the stuck backend, and all the transactions
that have occurred since that transaction started, would be useful
to look at.
regards, tom lane