MIME-Version: 1.0
References: <20250514112913.416cfc8f@msi>
In-Reply-To: <20250514112913.416cfc8f@msi>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 14 May 2025 12:42:31 -0400
Message-ID: 
 <CAKAnmmJ2FFFgcQEcti9GTr-HGZsiTL=5AMMtNQP1SJBNxB22=g@mail.gmail.com>
Subject: Re: Fillfactor question
To: Bzzzz <lazyvirus@gmx.com>
Cc: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000005dd06106351b3e65"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKAnmmJ2FFFgcQEcti9GTr-HGZsiTL%3D5AMMtNQP1SJBNxB22%3Dg%40mail.gmail.com>
Precedence: bulk

--0000000000005dd06106351b3e65
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, May 14, 2025 at 5:29=E2=80=AFAM Bzzzz <lazyvirus@gmx.com> wrote:

> does creating a table with fillfactor=3D75 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=3D# create table bzzzz(id int) with (fillfactor=3D75);
CREATE TABLE
greg=3D# create index bzzzz_index1 on bzzzz(id);
CREATE INDEX
greg=3D# create index bzzzz_index2 on bzzzz(id) with (fillfactor=3D42);
CREATE INDEX
greg=3D# select relname, relkind, reloptions from pg_class where relname ~
'bzzzz';
   relname    | relkind |   reloptions
--------------+---------+-----------------
 bzzzz        | r       | {fillfactor=3D75}
 bzzzz_index1 | i       | =E2=98=83
 bzzzz_index2 | i       | {fillfactor=3D42}
(3 rows)

Tables and indexes are both technically "relations", as seen in the
pg_class table above ("rel" =3D "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

--0000000000005dd06106351b3e65
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, May 14, 2025 at 5:29=E2=80=AFAM B=
zzzz &lt;<a href=3D"mailto:lazyvirus@gmx.com">lazyvirus@gmx.com</a>&gt; wro=
te:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">does creating a table with fillfactor=3D75=
 automatically propagate to its<br>
indexes or am I obliged to also modify their fillfactor accordingly ?<br></=
blockquote><div><br></div><div>They are separate, so you will need to modif=
y both. Here&#39;s a quick example:</div><div><br></div><div><font face=3D"=
monospace">greg=3D# create table bzzzz(id int) with (fillfactor=3D75);<br>C=
REATE TABLE<br>greg=3D# create index bzzzz_index1 on bzzzz(id);<br>CREATE I=
NDEX<br>greg=3D# create index bzzzz_index2 on bzzzz(id) with (fillfactor=3D=
42);<br>CREATE INDEX<br>greg=3D# select relname, relkind, reloptions from p=
g_class where relname ~ &#39;bzzzz&#39;;<br>=C2=A0 =C2=A0relname =C2=A0 =C2=
=A0| relkind | =C2=A0 reloptions<br>--------------+---------+--------------=
---<br>=C2=A0bzzzz =C2=A0 =C2=A0 =C2=A0 =C2=A0| r =C2=A0 =C2=A0 =C2=A0 | {f=
illfactor=3D75}<br>=C2=A0bzzzz_index1 | i =C2=A0 =C2=A0 =C2=A0 | =E2=98=83<=
br>=C2=A0bzzzz_index2 | i =C2=A0 =C2=A0 =C2=A0 | {fillfactor=3D42}<br>(3 ro=
ws)</font></div><div><br></div><div>Tables and indexes are both technically=
 &quot;relations&quot;, as seen in the pg_class table above (&quot;rel&quot=
; =3D &quot;relation&quot;). An index points to specific columns in a table=
, but otherwise is very distinct from it and no inheritance flows either di=
rection.</div><div>=C2=A0</div></div><div><br></div><div dir=3D"ltr" class=
=3D"gmail_signature"><div dir=3D"ltr"><div>Cheers,</div><div>Greg</div><div=
><br></div><div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchyd=
ata.com" target=3D"_blank">https://www.crunchydata.com</a></div><div>Enterp=
rise Postgres Software Products &amp; Tech Support</div><div><br></div></di=
v></div></div>

--0000000000005dd06106351b3e65--