Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIsyo-0001UU-CN for pgsql-admin@arkaria.postgresql.org; Tue, 02 Aug 2022 14:34:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oIsyn-0003qI-8Y for pgsql-admin@arkaria.postgresql.org; Tue, 02 Aug 2022 14:34:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIsym-0003q9-Sm for pgsql-admin@lists.postgresql.org; Tue, 02 Aug 2022 14:34:40 +0000 Received: from sonic305-2.consmr.mail.bf2.yahoo.com ([74.6.133.41]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oIsyi-00089X-La for pgsql-admin@postgresql.org; Tue, 02 Aug 2022 14:34:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1659450872; bh=ejVEYWXlPTlCRliRR8bp3li6XGLHdk9GmjZySFSS3mk=; h=From:To:Subject:Date:References:From:Subject:Reply-To; b=XKdeynM+x8R4iIrKO6WsRbfUf66pi/ARIIT7RE7V0n2VRzpzVd151ZR/ESWU2uq0Ai+9X7v4wi5NjO+WY9gWBgJihJQiYLhGs+r+Iuwf45TRJtHP6P46XM0m8Wp7rIPprDWybQ5xyIw00JXTQFG8jAUcqG9ET01k8hBRqa8abzWeIng3BnbWnpx2mdMIqFXwITnzcIrE0kpJqDBPRCBOIlKLVK5d0e0erpLL3HhJOqAarJFVUkPPCvHQcknvT3JakhGBXKOR/r/pdG6skQWerEdeXELkfYRCo2mIaFW2wPzxYzcRk4jA7e4NIm8FlLf7RCvCI4niYWEnr9+yefAoEQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1659450872; bh=729+U5tdwf0Q53EYt0zEkr8JDzbm9tJlbvcO5JYogZU=; h=X-Sonic-MF:From:To:Subject:Date:From:Subject; b=I9CVQUeO7YNX1XgSRKm6QHDweqhXOWBI0fCVObNxSWvUuv3r7lZuxCXZtW2gR4nuagpDzlz7WUzCynHm7qrKbQVz7xl434UiPuL1YKgv1OoaEVOWZMulUFEN/GE2D4FDmi/lmLM4DHv7GBRMoymrllVSw2VdetBpxX2Sd842zgvQcIlN3ZjqQROfHTomZE0EkgTxk3HpAgnOvkdYo37ubzyjVrDK8tlC5ldUFfZObrYS+XbFrRZOp7GQkAdX7vifUlMSwFTeomfA7O/RECe7O0c2keSjDa+XPNWYqAGuULph95w4O0WKnh2Ca87efoXuyaBgWBOjW89eFVKTuuDsuw== X-YMail-OSG: VL_zIZ4VM1kwHdswymVByWeyXdXS6zah742uJHF8JoCinzFFolrSXFfj2HsGqqM AvyC5E_ZkEwB5PoNNg1Ux.a0OccbXiTqEIUNA1zb.oqlpPvRX.YjDO7h4jwdFX08XKQ6DMrB2TLK fygJKh5vyFngMUc9oeYVxt6xuPCZotiMP4eX_LequNHvAtKzf1k8iAypbliP3CSXBgG6dfA3LqIX FdDlWSllSz.cQLQYnQq_lEyIL3S1ayC8UFT28ri1Y6zuZdTpOC0FY99NtVoDaWoIY6X5pwugG5EX MrP1DXfhG6LCiJTyjbvQJGuAG5r4RgJO2lXpplT7VUVV47KsQ8sSgLYs9FURI7sDsIKStx2WN3Op 0Z8gOFrMKOzM3ufmNDaCbCCJIwu5u2uEW9cOPS67_2DThofC_NZKt0dPLG6UGXvGhsyKwvpi1Jda dpD3G4Cq_jVxGoLj7ms.ZDkvfIbUXftJ4I7MtZm874B2fLwOpV00Lsizd3l9JqVraRpNArddQpR7 PitzJd..dR6Lof18v43nB7CjGjND1id7WiLcl9mc_19cauvVah8AfMESFudYGnC7UJ2fpHFNdCWo v6tj1fWwIK32guSBvGVUdwsOQF3jWx2LWORQJrzrNNkhj.Qjpmt8h3r.h2lxR4_aplIWNGk2O8EW gdbNp2hKfuyebcETXREU9KnjRG0Q5xMLBSXmaTEa8CiDvo.2tbLb4En648PYDDtwa2.5xQcbq_Oa zZPf9h0IhpOlPfBChaFHEEhSycAfFwh494h5iYwaZ07UIrR7q3hUk.HM6hWQ._7WWQS0nYKAIvNW pAZonU1zva_S4v1stCVSdrFCbHkGlEer7BThVDCume_VVlLWhlXeLMv_.49V12nD6qynuXSSIYt_ 5vSo1SwiWP8LY8zUoGUtl5F3vQRCOB5U.3To5lbC91KbxuxuzDWIedWttrBlt1QPIL7bzedxzMZt kkmjUtKd7NLRpvQZHWtNqu6UnIq1Fi_7._X9rs7J7aDycg3GejQ7.IS6NNGE7szeFMJdcSbm4J1Q U24oIjmFaOV88AbvRqxPdMmAvs_hDSzmekC3qIlcm1YUeYz5oO7.e5YQzp2mBmHWetaXY1UjPYY. MYHd06zUbrNvyF2HjKHiwaZwBnx3Pdckqlu4gXVFJFm8IB6VX2kYIVka4H6xFB8mLbs.wQ2ZGmYt CqiZcNgxdaZ6xw346U7zhsO5HnVMPmWsistWzarKmbPLEyLc6CP3cmcuKAnkEnSwXEMfWfwCIlXI sI_4GFAzomMZuMkTE6V8gzAE6VdCsoQudjOo8U0bMJ7ne6QlLb9Ntj0.nNp4iQ1aqArfyDHnWZcm qrKfI3b6q._uEGALUSkY0M867LnJe.ASRl4Kwz97Iej1_AJSmUlDgVPmPR8hemEmAv.9e48Wa.5F dtipPOk4LAf20dbdDp1nsxwe4vhVAaVJ.RG9.EdHZhBixqA9fYB5ooMPh87hLUCVhgHD0tBy7P7F 2.LWDrjk5EfBdDMol.KvvOO.a9aQwQFpEUWV3fZcpegu5a8bdkZUdNhCuXwJaLTAbUXf7d8ontr8 DA2jsAWmWZ_dkdefzURy_gRqgcp6oCdhR9bctZ4zjY_6C4P.cBxkc.1HCyLSTL3xIaizzg_oTA8l 8nI1URrKd1buRpWUMVwXKMG3wfL2xu1.DtPbi0C3ardnH6cSSfepmsgNq755fk9BRA_.h8m_HCDk LGe3RXXtrIjl..8JFyFKxSQ_vh45lMUgYDXgPQYFGEOSkZ.D_uZ_ZS.TtharC3bxaqpliGwxHMvy l39fQ0muO4HiD3Y4gdBq7bW47IObiMk8Ka.z2hgZLCqxmlKEEUlmuU6B0Bktd7lrluxOaE8Kzd2X o3AbKTr1vVCTDpdpZPmY8knMwcxXlFcTAkM6FYYQ9HGb8MpPckL.2diat12MsE3AF1xbBuJdSSrL ZBThy5qKFcyT4JCLgXMYYD2fMbaKy.ZUVUZuXOV1h4NSk4JRLWXVwv1JLCli6pQZGVjNu4ZjO4d3 CIONop_XdhRGpW2ZE8DPqgphDlo.Rt3_OvZr6klAaSBl65QY1SHim8z3gm37M2yq2iqS3F1P2U5V LmM6uBLh07DZkRhM08p7s0iSBQpWj802JL6YJ1XfZh2t.D7ubm_92Dsu42MkLfGCxbCxTGLEefOl B64woc5CZODde2Lb4ObxTCOEYZEEi6ec6tdlXBQaeJU2KArUyZXFar30BUde6hjMhDgBEzAq1p_x LhLs7qxsXeLhi2KvIiV76mg.qQIHPt3CyLr5M X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.bf2.yahoo.com with HTTP; Tue, 2 Aug 2022 14:34:32 +0000 Received: by hermes--production-gq1-7b45fb68df-98pz5 (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID 9ce40fc3c738278eca35b2421cae8d5a; Tue, 02 Aug 2022 14:34:28 +0000 (UTC) From: To: Subject: Partitioned table with fillfactor Date: Tue, 2 Aug 2022 10:34:27 -0400 Message-ID: <089f01d8a67c$f90c0660$eb241320$@yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_08A0_01D8A65B.71FB29B0" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQOHU7dy4OCptiIU9ZPlApnnw+hGyQ== Content-Language: en-us References: <089f01d8a67c$f90c0660$eb241320$.ref@yahoo.com> Content-Length: 2976 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_08A0_01D8A65B.71FB29B0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_08A0_01D8A65B.71FB29B0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

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 = =3D 80); , I get an Unrecognized parameter “fillfactor” = message.  Is it because I can’t use fillfactor with the = partitioned table?

 

Thank = you

Endre

------=_NextPart_000_08A0_01D8A65B.71FB29B0--