Postgres Pro
Downloads
Home   >   mailing lists

Re: Set fillfactor to partition child tables - Mailing list pgsql-admin

From Keith Fiske
Subject Re: Set fillfactor to partition child tables
Date
Msg-id CAODZiv4+m987f0NuQP4Rr1rvxa-T_SBiH3P+4AZAUFm5687RGw@mail.gmail.com
Whole thread Raw
In response to Set fillfactor to partition child tables  (Sathish Reddy <sathishreddy.postgresql@gmail.com>)
List pgsql-admin
Tree view


On Sat, Apr 20, 2024 at 6:54 AM Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:
Hi 
 I am using partam extension to create partition child tables.we tried to set fillfactor to child partition table but failed. please help us.

Thanks 
Sathish 

Relation options are not currently being inherited for declarative partitioning in core PostgreSQL. Some cannot even be set properly on the parent (Ex. unlogged). For version 4.5 and up of pg_partman, you can set relation options like this on the template table and they will be inherited from there.

--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: pga_schedule_jscmonthdays_size
Next
From: Tejaswi K T
Date:
Subject: Values Logged in Logfile of postgres logs