Postgres 16

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 t (name varchar, id int);

CREATE TABLE

insert into t(name, id) values ('a', 1) , ('b', 2), ('c', null)

INSERT 0 3

select * from t where id in (select id from t)

name
id

a
1

b
2

SELECT 2