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 tbl (
  int1    int
, int2    int
, product bigint GENERATED ALWAYS AS (int1 * int2) STORED
);

CREATE TABLE


INSERT INTO tbl(int1, int2)
VALUES
  (3, 4)
, (5, -6)
, (7, NULL);


INSERT 0 3


TABLE tbl;


int1
int2
product


3
4
12

5
-6
-30

7
null
null



SELECT 3