Re: Indexes on expressions with multiple columns and operators

2025-09-22 Thread Andrei Lepikhov
On 22/9/2025 15:37, Frédéric Yhuel wrote: I wonder if this is an argument in favour of decoupling the sample size and the precision of the statistics. Here, we basically want the sample size to be as big as the table in order to include the few (NULL, WARNING) values. I also have seen how repea

Re: Indexes on expressions with multiple columns and operators

2025-09-22 Thread Frédéric Yhuel
On 9/20/25 18:51, Tom Lane wrote: I concluded that maybe I was overthinking this part. We only really need to check the rowcount estimate, since the indexscan cost estimate is already okay. And stats_ext.sql seems to have gotten away with assuming that rowcount estimates are reliably reprodu

Re: Indexes on expressions with multiple columns and operators

2025-09-22 Thread Frédéric Yhuel
On 9/22/25 15:57, Andrei Lepikhov wrote: On 22/9/2025 15:37, Frédéric Yhuel wrote: I wonder if this is an argument in favour of decoupling the sample size and the precision of the statistics. Here, we basically want the sample size to be as big as the table in order to include the few (NULL