timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
16.83k stars 852 forks source link

[Bug]: Chunk index didn't carry over fillfactor from base table #7086

Open pgloader opened 5 days ago

pgloader commented 5 days ago

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)