Обсуждение: Partitioned table with fillfactor
Hello,
'PostgreSQL 11.13 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit'
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?
Thank you
Endre
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/
That makes sense, thank you! -----Original Message----- From: Simon Riggs <simon.riggs@enterprisedb.com> Sent: Tuesday, August 2, 2022 10:40 AM To: endre_pekarik@yahoo.com Cc: pgsql-admin <pgsql-admin@postgresql.org> Subject: Re: Partitioned table with fillfactor 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/