does creating a table with fillfactor=75 automatically propagate to its indexes or am I obliged to also modify their fillfactor accordingly ?
They are separate, so you will need to modify both. Here's a quick example:
greg=# create table bzzzz(id int) with (fillfactor=75); CREATE TABLE greg=# create index bzzzz_index1 on bzzzz(id); CREATE INDEX greg=# create index bzzzz_index2 on bzzzz(id) with (fillfactor=42); CREATE INDEX greg=# select relname, relkind, reloptions from pg_class where relname ~ 'bzzzz'; relname | relkind | reloptions --------------+---------+----------------- bzzzz | r | {fillfactor=75} bzzzz_index1 | i | ☃ bzzzz_index2 | i | {fillfactor=42} (3 rows)
Tables and indexes are both technically "relations", as seen in the pg_class table above ("rel" = "relation"). An index points to specific columns in a table, but otherwise is very distinct from it and no inheritance flows either direction.
