Postgres 12

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 people (
    height_cm numeric,
    height_in numeric GENERATED ALWAYS AS (height_cm * 2.54) STORED
);

CREATE TABLE

INSERT INTO people(height_cm)
VALUES(70),(80)

INSERT 0 2

SELECT * FROM people

height_cm
height_in

70
177.80

80
203.20

SELECT 2