Tom Lane wrote:
> Decibel! <decibel@decibel.org> writes:
> > Would it be worthwhile to allow for logging when a lock gets upgraded?
> > That would make it easier to protect against deadlocks...
>
> There is some debug code for that in the backend, but my experience
> is that it's too noisy to have on by default.
Seems a good idea to separate the upgrade bits from the other stuff and
enable it on --enable-cassert or something similar. TODO for 8.4?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support