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
INSERT 0 10
result |
---|
{ "Mexico": { "Jalisco": [ "Puerto Vallarta", "Guadalajara" ], "Baja California": [ "Tijuana" ] }, "United States": { "Central": { "Texas": [ "Houston" ], "Illinois": [ "Chicaco" ], "Missouri": [ "St Louis", "Wenztville", "Kansas City" ] }, "Eastern": { "New York": [ "New York City", "Manhattan" ] } } } |
SELECT 1