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 13.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit |
create table mytable (id int,name text) partition by range (name);
create table mytable_a partition of mytable for values from ('A') to ('B')Partition by range (name);
create table mytable_b partition of mytable for values from ('B') to('C')Partition by range (name);
select chr(ascii('Z')+1);
| chr |
|---|
| [ |
create table t3_ partition of mytable for values from ('Z') to ('[') Partition by range (name);
ERROR: empty range bound specified for partition "t3_"
DETAIL: Specified lower bound ('Z') is greater than or equal to upper bound ('[').