| From: | Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com> |
|---|---|
| To: | Sathish Reddy <sathishreddy(dot)postgresql(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Set fillfactor to partition child tables |
| Date: | 2024-04-22 16:01:01 |
| Message-ID: | CAODZiv4+m987f0NuQP4Rr1rvxa-T_SBiH3P+4AZAUFm5687RGw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, Apr 20, 2024 at 6:54 AM Sathish Reddy <
sathishreddy(dot)postgresql(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tejaswi K T | 2024-04-22 20:00:34 | Values Logged in Logfile of postgres logs |
| Previous Message | Holger Jakobs | 2024-04-22 15:51:50 | Re: pga_schedule_jscmonthdays_size |