Обсуждение: 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

От
Aditya Toshniwal
Дата:
Hi Endre,

This is the pgAdmin mailing list. You'll get a better response from PostgreSQL - pgsql-admin@postgresql.org mailing address.

On Mon, Aug 1, 2022 at 11:48 PM <endre_pekarik@yahoo.com> wrote:

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



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"