Re: Partitioned table with fillfactor - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Partitioned table with fillfactor
Date
Msg-id CANbhV-Hk87H8rNhgfdwKYiaUiQd9uOZ+NvjWVXy_8T5U0RwtFw@mail.gmail.com
Whole thread Raw
In response to Partitioned table with fillfactor  (<endre_pekarik@yahoo.com>)
Responses RE: Partitioned table with fillfactor  (<endre_pekarik@yahoo.com>)
List pgsql-admin
On Tue, 2 Aug 2022 at 15:34, <endre_pekarik@yahoo.com> wrote:

> I created a partitioned table. I didn’t load any data into it.
>
> When I try to ALTER TABLE tablename SET (fillfactor = 80); , I get an Unrecognized parameter “fillfactor” message.
Isit because I can’t use fillfactor with the partitioned table? 

"Specifying these parameters for partitioned tables is not supported,
but you may specify them for individual leaf partitions."
https://www.postgresql.org/docs/11/sql-createtable.html

Still same restriction with PG14.

--
Simon Riggs                http://www.EnterpriseDB.com/



pgsql-admin by date:

Previous
From:
Date:
Subject: Partitioned table with fillfactor
Next
From:
Date:
Subject: RE: Partitioned table with fillfactor