Postgres 11

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 T(ID text);
INSERT INTO T VALUES ('https://www.example.com');

CREATE TABLE

INSERT 0 1

SELECT * FROM T WHERE ID IS 'https://www.example.com';

ERROR:  syntax error at or near "'https://www.example.com'"
LINE 1: SELECT * FROM T WHERE ID IS 'https://www.example.com';
                                    ^

SELECT * FROM T WHERE ID = 'https://www.example.com';

id

https://www.example.com

SELECT 1