Обсуждение: Set fillfactor to partition child tables

Поиск
Список
Период
Сортировка

Set fillfactor to partition child tables

От
Sathish Reddy
Дата:
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

От
Keith Fiske
Дата:


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