public inbox for [email protected]help / color / mirror / Atom feed
Fillfactor question 3+ messages / 2 participants [nested] [flat]
* Fillfactor question @ 2025-05-14 09:29 Bzzzz <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Bzzzz @ 2025-05-14 09:29 UTC (permalink / raw) To: [email protected] 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 -- ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Fillfactor question @ 2025-05-14 16:42 Greg Sabino Mullane <[email protected]> parent: Bzzzz <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Greg Sabino Mullane @ 2025-05-14 16:42 UTC (permalink / raw) To: Bzzzz <[email protected]>; +Cc: [email protected] 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Fillfactor question @ 2025-05-14 16:57 Bzzzz <[email protected]> parent: Greg Sabino Mullane <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Bzzzz @ 2025-05-14 16:57 UTC (permalink / raw) To: [email protected] On Wed, 14 May 2025 12:42:31 -0400 Greg Sabino Mullane <[email protected]> wrote: > 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. OK, too bad indexes fillfactor do not follow the one of their table by default :/ Thanks, Greg. Jean-Yves -- ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-05-14 16:57 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-05-14 09:29 Fillfactor question Bzzzz <[email protected]> 2025-05-14 16:42 ` Greg Sabino Mullane <[email protected]> 2025-05-14 16:57 ` Bzzzz <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox