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?.
sum | ?column? |
---|---|
5000050000 | 00:00:00.015017 |
mysum_fast | ?column? |
---|---|
5000050000 | 00:00:00.045341 |
mysum_slow | ?column? |
---|---|
null | 00:00:00.230979 |