public inbox for [email protected]  

help / color / mirror / Atom feed

From: Greg Sabino Mullane <[email protected]>
To: Bzzzz <[email protected]>
Cc: [email protected]
Subject: Re: Fillfactor question
Date: Wed, 14 May 2025 12:42:31 -0400
Message-ID: <CAKAnmmJ2FFFgcQEcti9GTr-HGZsiTL=5AMMtNQP1SJBNxB22=g@mail.gmail.com> (raw)
In-Reply-To: <20250514112913.416cfc8f@msi>
References: <20250514112913.416cfc8f@msi>

On Wed, May 14, 2025 at 5:29 AM Bzzzz <[email protected]> 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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Fillfactor question
  In-Reply-To: <CAKAnmmJ2FFFgcQEcti9GTr-HGZsiTL=5AMMtNQP1SJBNxB22=g@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox