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?.
SELECT 1
jsonb_pretty |
---|
{ "A": [ { "index": "1" }, { "index": "2" } ], "B": [ { "index": "3" }, { "index": "4" } ] } |
SELECT 1
UPDATE 1
jsonb_pretty |
---|
{ "A": [ { "index": "1", "myArray": [ ] }, { "index": "2", "myArray": [ ] } ], "B": [ { "index": "3" }, { "index": "4" } ] } |
SELECT 1