Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE TABLe MovieAwards (Title varchar(10), year int,result varchar(5))

CREATE TABLE

CREATE TABLe Movies (Title varchar(10), year int)

CREATE TABLE

SELECT COUNT(*)::FLOAT
  FROM MovieAwards 
  WHERE EXISTS (SELECT DISTINCT * FROM Movies WHERE MovieAwards.title = Movies.title AND Movies.year = MovieAwards.year AND Movies.year >= 2000 AND Movies.year <= 2010 AND MovieAwards.result='won')
GROUP BY "title","year";

count

SELECT 0