Postgres 15

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 table_name (
    id serial primary key,
    column_name varchar(200)
);

INSERT INTO table_name (column_name)
VALUES ('{"boom": "goes the dynamite", "foo": "bar", "number": 42}');

CREATE TABLE

INSERT 0 1

select * from table_name

id
column_name

1
{"boom": "goes the dynamite", "foo": "bar", "number": 42}

SELECT 1

UPDATE table_name
SET column_name = (column_name::jsonb - 'boom')::text
WHERE 1=1;

UPDATE 1

select * from table_name

id
column_name

1
{"foo": "bar", "number": 42}

SELECT 1