> > > > > > Reading [1], I think I can follow what you suggest. So, basically, > > if the leftmost column is not filtered, we have the following: > > > >> but the entire index would have to be scanned, so in most cases the planner > would prefer a sequential table scan over using the index. > > > > > > So, in our case, we could follow a similar approach. If the leftmost column of > the index > > is not sent over the wire from the pub, we can prefer the sequential scan. > > > > Is my understanding of your suggestion accurate? > > > > Yes. I request an opinion from Shi-San who has reported the problem. >
I also agree with this. And I think we can mention this in the comments if we do so.
Already commented on FindUsableIndexForReplicaIdentityFull() on v44.