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 price (
  isin varchar(50) NOT NULL,
  nemo varchar(50) NOT NULL,
  "Month(t)" int NOT NULL,
  "Month(t-1)" int NOT NULL,
  "Month(t-2)" int NOT NULL
)

CREATE TABLE


insert into price (isin, nemo, "Month(t)","Month(t-1)", "Month(t-2)")
  values ('111', 'nemo', 1, 100, 1000);

INSERT 0 1


select *
from price


isin
nemo
Month(t)
Month(t-1)
Month(t-2)


111
nemo
1
100
1000



SELECT 1