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?.
SELECT 5
state | city | contacts |
---|---|---|
CA | {city1,city2} | {person10,person11,person12,person7,person8,person9} |
NY | {city1,city2} | {person1,person2,person3,person4,person5,person6} |
SELECT 2