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?.
INSERT 0 3
UPDATE 3
name | grp |
---|---|
joe | [{"gid": "1", "ona": "joe", "tit": "newTitle Group 1 "}, {"gid": "2", "ona": "harry", "tit": "tester1 group 2"}, {"gid": "3", "ona": "moe", "tit": "group 3"}] |
harry | [{"gid": "1", "ona": "joe", "tit": "newTitle Group 1 "}, {"gid": "2", "ona": "harry", "tit": "tester1 group 2"}, {"gid": "3", "ona": "moe", "tit": "group 3"}] |
moe | [{"gid": "1", "ona": "joel", "tit": "newTitle Group 1 "}, {"gid": "2", "ona": "harry", "tit": "tester1 group 2"}, {"gid": "3", "ona": "moe", "tit": "group 3"}] |
SELECT 3