Hi Andres, Amit, all I think the case in which the patch regresses performance in is irrelevant > in > practice. >
This is similar to what I think in this context. I appreciate the effort from Shi Yu, so that we have a clear understanding on the overhead. But the tests we do on [1] where we observe the regression are largely synthetic test cases that aim to spot the overhead. And having an index over thousands > of non-differing values will generally perform badly, not just in this > context. Similarly, maybe there are some eccentric use patterns that might follow this. But I also suspect even if there are such patterns, could they really be performance sensitive? Thanks, Onder KALACI [1] https://www.postgresql.org/message-id/OSZPR01MB63103A4AFBBA56BAF8AE7FAAFDA39%40OSZPR01MB6310.jpnprd01.prod.outlook.com