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
INSERT 0 3
UPDATE 3
| jsondata | jsonbdata |
|---|---|
| {"key1":{"value":"value1","order":2},"key2":{"value":"value2","order":1}} | {"key1": {"order": 2, "value": "value1"}, "key2": {"order": 1, "value": "value2"}} |
| {"key2":{"value":"value1","order":2},"key1":{"value":"value2","order":1}} | {"key1": {"order": 1, "value": "value2"}, "key2": {"order": 2, "value": "value1"}} |
| {"key1":{"order":2,"value":"value1"},"key2":{"value":"value2","order":1},"key1":{"order":3,"value":"value3"}} | {"key1": {"order": 3, "value": "value3"}, "key2": {"order": 1, "value": "value2"}} |
SELECT 3