Thread

1. Fillfactor question

   Bzzzz <lazyvirus@gmx.com> — 2025-05-14T09:29:13Z

   Hi,
   
   does creating a table with fillfactor=75 automatically propagate to its
   indexes or am I obliged to also modify their fillfactor accordingly ?
   
   Jean-Yves
   
   -- 
   
   
   
   

2. Re: Fillfactor question

   Greg Sabino Mullane <htamfids@gmail.com> — 2025-05-14T16:42:31Z

   On Wed, May 14, 2025 at 5:29 AM Bzzzz <lazyvirus@gmx.com> wrote:
   
   > 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.
   
   
   Cheers,
   Greg
   
   --
   Crunchy Data - https://www.crunchydata.com
   Enterprise Postgres Software Products & Tech Support
   

3. Re: Fillfactor question

   Bzzzz <lazyvirus@gmx.com> — 2025-05-14T16:57:47Z

   On Wed, 14 May 2025 12:42:31 -0400
   Greg Sabino Mullane <htamfids@gmail.com> wrote:
   
   > On Wed, May 14, 2025 at 5:29 AM Bzzzz <lazyvirus@gmx.com> wrote:
   > 
   > > 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.
   
   OK, too bad indexes fillfactor do not follow the one of their table by
   default :/
   
   Thanks, Greg.
   
   Jean-Yves
   
   --