Re: Partitioned table with fillfactor

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 2 Aug 2022 at 15:34, <endre_pekarik@xxxxxxxxx> 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/






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux