On Sun, Oct 01, 2006 at 12:55:51PM +0200, MaXX wrote:
>
> Pure speculation: are you sure you aren't vacuuming too agressively?
> The DELETE waiting and SELECT waiting sound to me like they are waiting
> for a lock that another vacuum is holding.
How would one determine the lock situation definitively? Is there
an internal mechanism that can be queried?