Re: Set fillfactor to partition child tables

[Keith Fiske <keith.fiske@xxxxxxxxxxxxxxx>]

On Sat, Apr 20, 2024 at 6:54 AM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> 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