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?.

select version();


version


PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit



SELECT 1


create table tabla(
  fecha date,
  id_cliente int,
  pago int,
  vendedor int  
);

CREATE TABLE


insert into tabla values
('2021-09-03',1,1946,12310),
('2021-09-09',1,1257,12310),
('2021-09-22',1,1299,12307);

INSERT 0 3


select * from tabla join (
  select vendedor,
    max(fecha) fecha
    from tabla
    group by 1
) c1 using(fecha,vendedor)
  order by 1 desc;


fecha
vendedor
id_cliente
pago


2021-09-22
12307
1
1299

2021-09-09
12310
1
1257



SELECT 2