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 TABLE
INSERT 0 8
| id | str |
|---|---|
| 1 | Строка A |
| 2 | Строка S |
| 3 | Строка D |
| 4 | Строка F |
| 5 | Строка G |
| 6 | Строка H |
| 7 | Строка J |
| 8 | Строка K |
SELECT 8
| reverse |
|---|
| A акортС |
| Строка S |
| D акортС |
| Строка F |
| G акортС |
| Строка H |
| J акортС |
| Строка K |
SELECT 8