Postgres 14

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 numbers (flags bit(10000000));
insert into numbers (flags)
values (repeat('0', 10000000)::bit varying);
1 rows affected

update numbers
  set flags = set_bit(flags, 10000000 - 1, 1);

update numbers
  set flags = set_bit(flags, 42, 1);

select get_bit(flags, 42)
from numbers;

1 rows affected

1 rows affected

get_bit

1

select bit_length(flags), bit_count(flags)
from numbers;

bit_length
bit_count

10000000
2

select pg_size_pretty(pg_total_relation_size('numbers'))

pg_size_pretty

96 kB