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?.
base_text | base_id |
---|---|
null | null |
null | null |
null | null |
base_text | base_id |
---|---|
Red Large Special | 1 |
Blue Small | 5 |
Green Medium Special | 87 |