Thread: 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
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"