Fabrice Scemama <fabrice@scemama.org> writes:
> With 7.0.x versions, we've come across a problem, new for us:
> very often (2 or 3 times a day), there are on our Pg machine
> a dozen of 'update waiting', and our perl scripts are waiting
> too to begin a transaction.
Can you list exactly what *all* the backends are doing when this
happens? It might help to run the postmaster with -d2 so that
the postmaster log contains a trace of all queries executed.
> - Am I the only one here to have such problems with 7.0.2?
Haven't seen any other such reports.
regards, tom lane