Postgres 12

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 test (id int [])

CREATE TABLE

insert into test values ( ARRAY [1,2,3] )

INSERT 0 1

insert into test values ( ARRAY [ARRAY [1,2,3],ARRAY [1,2,4],ARRAY [1,2,5]] )

INSERT 0 1

select * from test

id

{1,2,3}

{{1,2,3},{1,2,4},{1,2,5}}

SELECT 2