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?.

SELECT 'SRID=4269;POINT(0 0)'::GEOGRAPHY(GEOMETRY, 4269)

geography

0101000020AD10000000000000000000000000000000000000

SELECT 1

SELECT 'SRID=4269;POINT(0 0)'::GEOGRAPHY(POINT, 4269)

geography

0101000020AD10000000000000000000000000000000000000

SELECT 1

SELECT ST_Transform(ST_SetSRID(ST_MakePoint(0, 0), 4326), 4269)::GEOGRAPHY(GEOMETRY, 4269)

st_transform

0101000020AD10000000000000000000000000000000000000

SELECT 1

SELECT ST_Transform(ST_SetSRID(ST_MakePoint(0, 0), 4326), 4269)::GEOGRAPHY(POINT, 4269)

st_transform

0101000020AD10000000000000000000000000000000000000

SELECT 1