On Wed, Oct 30, 2024 at 10:35 AM Peter Geoghegan <pg@bowt.ie> wrote:
On Wed, Oct 30, 2024 at 11:24 AM Don Seiler <don@seiler.us> wrote: > One thing worth mentioning is that the table is 4 columns, the index is on two of them and includes the other two. I can't think of an explanation for the index being so much larger than its table, especially compared to last month's index. > > Curious if anyone has any thoughts on what might be causing this.
You mentioned that this has 4 columns. Sounds like this could be a "locally monotonically increasing index". I wonder if you're benefiting from this optimization, though only inconsistently:
