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 tab
AS
SELECT 1 AS id
UNION ALL
SELECT 2 AS id
UNION ALL
SELECT 3
SELECT 3
SELECT *
FROM tab
ORDER BY id DESC
LIMIT CASE WHEN 1=1 THEN 1
END
| id |
|---|
| 3 |
SELECT 1
SELECT *
FROM tab
ORDER BY id DESC
LIMIT CASE WHEN 1=2 THEN 1
END
| id |
|---|
| 3 |
| 2 |
| 1 |
SELECT 3