Thread: PG_PARTMAN - Create Child With FillFactor
Hi Team,
I’ve a requirement:
“I need fill_factor to be applied automatically to child tables when they’re created during “Create Parent” function in pg_partman. We tried our hands dirty by editing the procedure of pg_partman, and yet we didn’t achieve the desired outcome. However, we could achieve it using “ALTER TABLE” functionality which we inscribed in the procedure after creation of child tables. But this is not what we wanted to achieve. We require it to run during creation of these child tables. We don’t need it to alter after its creation.
Regards,
Phani
Attachment
Hi Team,
I’ve a requirement:
“I need fill_factor to be applied automatically to child tables when they’re created during “Create Parent” function in pg_partman. We tried our hands dirty by editing the procedure of pg_partman, and yet we didn’t achieve the desired outcome. However, we could achieve it using “ALTER TABLE” functionality which we inscribed in the procedure after creation of child tables. But this is not what we wanted to achieve. We require it to run during creation of these child tables. We don’t need it to alter after its creation.
Regards,
Phani