| From: | Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Cc: | Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com> |
| Subject: | PG_PARTMAN - Create Child With FillFactor |
| Date: | 2024-03-22 08:23:46 |
| Message-ID: | AS4PR10MB55458BB2A09A9ED09002582B8D312@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 | Content-Type | Size |
|---|---|---|
| pg_partman_create_parent.sql | application/octet-stream | 29.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2024-03-22 10:03:46 | Re: Ora2pg migration |
| Previous Message | Narendran .j | 2024-03-22 05:38:02 | Ora2pg migration |