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 COLLATION
CREATE TABLE
| dimension |
|---|
| 8 |
| 1.5 |
| 1.4 |
| 1 |
| 10 |
| 0 |
| 10-14 |
| 12 |
| 14-20 |
| 93.5in |
| ABC |
INSERT 0 11
| dimension |
|---|
| 0 |
| 1 |
| 1.4 |
| 1.5 |
| 8 |
| 10 |
| 10-14 |
| 12 |
| 14-20 |
| 93.5in |
| ABC |
SELECT 11