Partitioned table with fillfactor

From: <endre_pekarik(at)yahoo(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Partitioned table with fillfactor
Date: 2022-08-02 14:34:27
Message-ID: 089f01d8a67c$f90c0660$eb241320$@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2022-08-02 14:39:47 Re: Partitioned table with fillfactor
Previous Message Don Seiler 2022-08-02 13:26:27 WAL restore/recovery fills pg_wal volume