From: endre_pekarik@yahoo.com
To: 'Simon Riggs' <simon.riggs@enterprisedb.com>
Cc: 'pgsql-admin' <pgsql-admin@postgresql.org>
Subject: RE: Partitioned table with fillfactor
Date: Tue, 2 Aug 2022 11:50:34 -0400
Message-ID: <097901d8a687$9b981220$d2c83660$@yahoo.com> (raw)
In-Reply-To: <CANbhV-Hk87H8rNhgfdwKYiaUiQd9uOZ+NvjWVXy_8T5U0RwtFw@mail.gmail.com>
References: <089f01d8a67c$f90c0660$eb241320$.ref@yahoo.com>
<089f01d8a67c$f90c0660$eb241320$@yahoo.com>
<CANbhV-Hk87H8rNhgfdwKYiaUiQd9uOZ+NvjWVXy_8T5U0RwtFw@mail.gmail.com>
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. Is it 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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: endre_pekarik@yahoo.com, simon.riggs@enterprisedb.com
Subject: RE: Partitioned table with fillfactor
In-Reply-To: <097901d8a687$9b981220$d2c83660$@yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox