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?.
version |
---|
PostgreSQL 14.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit |
SELECT 1
CREATE FUNCTION
years | category |
---|---|
0 | BABY BOOMER |
SELECT 1
years | category |
---|---|
30 | LONER |
SELECT 1
years | category |
---|---|
null | null |
SELECT 1
years | category |
---|---|
20 | MILLENIAL |
SELECT 1
years | category |
---|
SELECT 0