On Mon, Nov 4, 2019 at 12:32 PM Jeff Janes <jeff.janes@gmail.com> wrote:
> Could there be a long-open transaction, which is preventing hint-bits from getting on set on the table rows, as well
onthe index rows?
Contention on a small number of rows may also be a factor.
> A reindex would not by itself fix the problem if it were the long open transaction. But if the long open
transactionheld a sufficient lock on the table, then the reindex would block until the transaction went away on its
own,at which point the problem would go away on its own, so it might **appear** to have fixed the problem.
That seems like the simplest and most likely explanation to me, even
though it isn't particularly simple.
--
Peter Geoghegan