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.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit |
7 rows affected
old_label | new_label |
---|---|
null | 0 |
foo | 1 |
SET1024 | 1 |
17 | 17 |
.123 | .123 |
4.56 | 4.56 |
9. | 9. |