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

create table a (
   id int not null primary key
 , val text
);

insert into a
select n, 'A-' || n::text
  from generate_series(1,4) n;
  
select *
  from a;
4 rows affected



id
val


1
A-1

2
A-2

3
A-3

4
A-4


create table b (
   id int not null primary key
 , val text
);

insert into b
select n, 'B-' || n::text
  from generate_series(3,7) n;
  
select *
  from b;
5 rows affected



id
val


3
B-3

4
B-4

5
B-5

6
B-6

7
B-7


insert into a
select *
  from b
ON CONFLICT DO NOTHING;

select *
  from a;
3 rows affected



id
val


1
A-1

2
A-2

3
A-3

4
A-4

5
B-5

6
B-6

7
B-7