Обсуждение: Partitioned table with fillfactor

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

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

Re: Partitioned table with fillfactor

От
Simon Riggs
Дата:
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/



RE: Partitioned table with fillfactor

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