Re: hung backends stuck in spinlock heavy endless loop
From:
Peter Geoghegan <pg(at)heroku(dot)com>
To:
Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc:
Andres Freund <andres(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: hung backends stuck in spinlock heavy endless loop
This is great, but it's not exactly clear which bt_page_items() page is which - some are skipped, but I can't be sure which. Would you mind rewriting that query to indicate which block is under consideration by bt_page_items()?