RE: Bad estimate with partial index

2022-04-20 Thread André Hänsel
Tomas Vondra wrote: > Andre, are you in position to test this fix with your application? Which > Postgres version are you using, actually? There's a test case in my original email, which obviously was synthetic, but I could also test this with my original application data if I can get a

Bad estimate with partial index

2022-04-19 Thread André Hänsel
Hi list, I have a case where Postgres chooses the wrong index and I'm not sure what to do about it: https://dbfiddle.uk/?rdbms=postgres_14=f356fd56a920ea8a93c192f5a8c16b 1c Setup: CREATE TABLE t ( filename int, cropped bool not null default false, resized bool not null default