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 test (verysmallinteger char(1)) ;

CREATE TABLE

-- storing integers from 1 to 32 into column verysmallinteger
insert into test 
select chr(i+32)
from generate_series(1,32) AS i

INSERT 0 32

-- querying values stored in column verysmallinteger
select ascii(verysmallinteger)-32 from test order by 1

?column?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

SELECT 32