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 type ty_gal as (
  id int
, name text
, stuff text
);

create table gal1 of ty_gal;
create table gal2 of ty_gal;

insert into gal1 values
(1, '小島南', '測試用'),
(2, '初川南', '測試用');

insert into gal2 values
(3, '相沢南', '測試用'),
(4, '小宵虎南', '測試用');
2 rows affected

2 rows affected

alter type ty_gal
 drop attribute stuff cascade;
alter type ty_gal
  add attribute products text[] cascade;
update gal1
   set products = array['SSIS-340', 'SSIS-315']
 where id = 1;
 
update gal1
   set products = array['BBAN-359', 'SHKD-987']
 where id = 2;
 
update gal2
   set products = array['IPX-819', 'IPX-801']
 where id = 3;
 
update gal2
   set products = array['SSIS-309', 'SSIS-281']
 where id = 4;
1 rows affected

1 rows affected

1 rows affected

1 rows affected

select *
  from gal1
union all
select *
  from gal2
order by id;


id
name
products


1
小島南
{SSIS-340,SSIS-315}

2
初川南
{BBAN-359,SHKD-987}

3
相沢南
{IPX-819,IPX-801}

4
小宵虎南
{SSIS-309,SSIS-281}

id	name	products
1	小島南	{SSIS-340,SSIS-315}
2	初川南	{BBAN-359,SHKD-987}
3	相沢南	{IPX-819,IPX-801}
4	小宵虎南	{SSIS-309,SSIS-281}