timescaledb
timescaledb copied to clipboard
[Bug]: Chunk index didn't carry over fillfactor from base table
What type of bug is this?
Other
What subsystems and features are affected?
Other
What happened?
I have set fillfactor of an hypertable index as 60% . However, the index on the chunk didn't carry over the fillfactor
select t.relname as table_name, t.reloptions
from pg_class t join pg_namespace n on n.oid = t.relnamespace where t.relname in ('table_60_pkey', '46_35_table_60_pkey'); table_name | reloptions ---------------------------+----------------- 46_35_table_60_pkey | table_60_pkey | {fillfactor=60} (2 rows)
TimescaleDB version affected
2.15.2
PostgreSQL version used
16.3
What operating system did you use?
RHEL8.6
What installation method did you use?
Other
What platform did you run on?
On prem/Self-hosted
Relevant log output and stack trace
# select t.relname as table_name, t.reloptions
from pg_class t
join pg_namespace n on n.oid = t.relnamespace
where t.relname in ('table_60_pkey', '46_35_table_60_pkey');
table_name | reloptions
---------------------------+-----------------
46_35_table_60_pkey |
table_60_pkey | {fillfactor=60}
(2 rows)
How can we reproduce the bug?
# select t.relname as table_name, t.reloptions
from pg_class t
join pg_namespace n on n.oid = t.relnamespace
where t.relname in ('table_60_pkey', '46_35_table_60_pkey');
table_name | reloptions
---------------------------+-----------------
46_35_table_60_pkey |
table_60_pkey | {fillfactor=60}
(2 rows)