On Tue, 2 Aug 2022 at 15:34, <endre_pekarik(at)yahoo(dot)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. Is it 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/