From: <endre_pekarik@yahoo.com>
To: "'Simon Riggs'" <simon.riggs@enterprisedb.com>
Cc: "'pgsql-admin'" <pgsql-admin@postgresql.org>
References: <089f01d8a67c$f90c0660$eb241320$.ref@yahoo.com>
 <089f01d8a67c$f90c0660$eb241320$@yahoo.com>
 <CANbhV-Hk87H8rNhgfdwKYiaUiQd9uOZ+NvjWVXy_8T5U0RwtFw@mail.gmail.com>
In-Reply-To: 
 <CANbhV-Hk87H8rNhgfdwKYiaUiQd9uOZ+NvjWVXy_8T5U0RwtFw@mail.gmail.com>
Subject: RE: Partitioned table with fillfactor
Date: Tue, 2 Aug 2022 11:50:34 -0400
Message-ID: <097901d8a687$9b981220$d2c83660$@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQJKnbrXFktiI1K4pHNs1xqvkC7E4AMDXJ9WAIqBVmWsm2TAQA==
Content-Language: en-us
Content-Length: 906
Archived-At: 
 <https://www.postgresql.org/message-id/097901d8a687%249b981220%24d2c83660%24%40yahoo.com>
Precedence: bulk

That makes sense, thank you!

-----Original Message-----
From: Simon Riggs <simon.riggs@enterprisedb.com>=20
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=E2=80=99t load any data into it.
>
> When I try to ALTER TABLE tablename SET (fillfactor =3D 80); , I get =
an Unrecognized parameter =E2=80=9Cfillfactor=E2=80=9D message.  Is it =
because I can=E2=80=99t 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.

--=20
Simon Riggs                http://www.EnterpriseDB.com/