Postgres 14

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 version();


version


PostgreSQL 14.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit



SELECT 1


    create table t
    ( tid serial primary key,
      i int default 0,
      name text default 'Jack'
    ) ;

CREATE TABLE


    insert into t (i)
      OVERRIDING USER VALUE
    select null
    from generate_series(1, 10) as gs(i) ;

INSERT 0 10


select * from t ;


tid
i
name


1
null
Jack

2
null
Jack

3
null
Jack

4
null
Jack

5
null
Jack

6
null
Jack

7
null
Jack

8
null
Jack

9
null
Jack

10
null
Jack



SELECT 10

tid	i	name
1	null	Jack
2	null	Jack
3	null	Jack
4	null	Jack
5	null	Jack
6	null	Jack
7	null	Jack
8	null	Jack
9	null	Jack
10	null	Jack