Thread: Set fillfactor to partition child tables

Set fillfactor to partition child tables

From
Sathish Reddy
Date:
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 

Re: Set fillfactor to partition child tables

From
Keith Fiske
Date:


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