Postgres 13

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 employees (
  id SERIAL NOT NULL PRIMARY KEY,
  name TEXT NOT NULL,
  salary BIGINT NOT NULL
);

CREATE TABLE


INSERT INTO employees(name, salary) VALUES
  ('Alice', 2000),
  ('Bob', 3000),
  ('Charlie', 2000),
  ('David', 2000),
  ('Eddie', 1500);

INSERT 0 5


SELECT * FROM employees;


id
name
salary


1
Alice
2000

2
Bob
3000

3
Charlie
2000

4
David
2000

5
Eddie
1500



SELECT 5


SELECT * FROM employees
ORDER BY salary DESC
LIMIT 2;


id
name
salary


2
Bob
3000

1
Alice
2000



SELECT 2


SELECT * FROM employees
ORDER BY salary DESC
FETCH FIRST 2 ROWS ONLY;


id
name
salary


2
Bob
3000

1
Alice
2000



SELECT 2


SELECT * FROM employees
ORDER BY salary DESC
FETCH FIRST 2 ROWS WITH TIES;


id
name
salary


2
Bob
3000

1
Alice
2000

3
Charlie
2000

4
David
2000



SELECT 4