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 FUNCTION
CREATE FUNCTION
CREATE FUNCTION
question | response_id | response |
---|---|---|
Who? | 1 | Here. |
When? | 2 | Now. |
WHY? | 3 | Because. |
SELECT 3
question | response_id | response |
---|---|---|
Who? | 1 | Here. |
When? | 2 | Now. |
WHY? | 3 | Because. |
SELECT 3
question | response_id | response |
---|---|---|
Who? | 1 | Here. |
When? | 2 | Now. |
WHY? | 3 | Because. |
SELECT 3