On Mon, Nov 4, 2019 at 12:32 PM Jeff Janes <jeff.ja...@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 on the 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 transaction held 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
