Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vr3Se-005dCZ-0r for pgsql-general@arkaria.postgresql.org; Sat, 14 Feb 2026 00:24:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vr3Sd-00Gn3L-0J for pgsql-general@arkaria.postgresql.org; Sat, 14 Feb 2026 00:24:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vr3Sc-00Gn3D-26 for pgsql-general@lists.postgresql.org; Sat, 14 Feb 2026 00:24:34 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vr3SZ-00000000Wmi-3XAc for pgsql-general@lists.postgresql.org; Sat, 14 Feb 2026 00:24:33 +0000 Received: by mail-ed1-x52a.google.com with SMTP id 4fb4d7f45d1cf-65b94df5ef7so1959642a12.2 for ; Fri, 13 Feb 2026 16:24:32 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771028671; cv=none; d=google.com; s=arc-20240605; b=L4ZS796avbDu9gA0Q88SdNnbWQ+/SEKL4pjhkU5kufzuCPlrd1J8JyQ0COd594zUth fmWk4gxkKCae9+MdQ0DESn0j1L/H1sZT7/400arxJlKHfdce+AosZWyb+D94HTQRT8jy 30dGUUKJ7PZR205XGlrpa8wuNeLjKy++NXpiIRbOi22jIfvW428pPPUq45t65QGGl40g JX3gywvln3uUcx+EOFPzk1LG8EPgV5Hc++aQxwfRry01/VAE4Y9NHVRihmN9tVGOo142 HUO3Fvl223ba0tesRVkR23/Qgq8Kix2416Iz3GVlgW/mgTCfSbLhOEu0dNAua4PdbUMs H87w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=abH5bzZbTuF9gvYyCqzl7qUNPYmIw6Occlr+j7ahntM=; fh=JVqOflqgGvOczmHqZY3QyEWPTDi7mjb1P7Q68F+Tamg=; b=MqW8SvE+LNrUz17klHrSfIzfTFbD86XxACQFz1WI26HT0bdx/rxo2idEeWOebxrrEq RtbQwVThBgGABS03tRqxHF3jhZztzBxTxr27lkIcL9sjggjY6NFjoW9OkNrIdsiBTp+Y v99mJot7uBWcBs4B5cZpK6RewWDXCLG7p/fsxtR3ja/qVzWS4jzh1srP1sOO9oajEXgb Iby4XBzwNsgKYI2S0h0+jdvN1ITN2TRWMFc1TdBOYD9SfRCGhx9pjTSFJey/sMprd+Fv 1G8z0a0+PepqjpaxG3ecYgaKvefgOjmL8PpnGrqAafE3NhZbHQzoCx+uMjZNqTw8/mKz 3plQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1771028671; x=1771633471; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=abH5bzZbTuF9gvYyCqzl7qUNPYmIw6Occlr+j7ahntM=; b=eI+zoP2b/DrYgtBIdPTUvic+O7eAG3Qco48Jnv/T9lXX1ajHEsmM7GZt89oWTzh1bp T3/69+FplXqBz1xRsP4A3SGVYf2GGsV1EWJyKVDg/rQJSR1LqebExOnuMRR8Zjf5ZdIr aUqUXBslt8KEFlu4uxPTYwgli1tpC+wek7CuKS0JaQNTiTObHQ66VppvqHSpumm/s9xR nlt9AM5dDgg+QyX/TSUziPL9jrQBRbbBIkHNEnvQh1i6PS0PVKMNsaZn/FI0deRUsoVU ES7oJ0LPcMER2Za7bW3LIKA7TzhsQ24kZ11NTG0k3eCZIV0w57PpEXHyQNAjhAVi7mv/ xsoA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771028671; x=1771633471; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=abH5bzZbTuF9gvYyCqzl7qUNPYmIw6Occlr+j7ahntM=; b=sZDIZRTu0gMglBYMgFcEfnJmz8Ui66PABidkD04Gwa0Zup6bUs8z91hqoKWxGbVGN1 zfYgeQ08LVZRIcm//x2NwrM7yhgVQrZj2oOmn1fp7Nu4tVXtWvJ4MN4FYyTOf58nWofh OCVvILbxZXcKO/8bybSGWHH1HRl4ABtUtroAob1hWrvtyZ5RQT4rXDMcc25HOHhG1n2I bbuTfrdrEfEnm0MEBipGzghT7qPlchaEDwguz20Y46vxCJZZp7XvVRwdaMT0h3DBNZb8 icwVayHdAvck47aVKCoO4Hfo88ymWDY8+sGqZrcDbuq85/5ZgE6lMoquuupO8wBrpu1S iIMQ== X-Gm-Message-State: AOJu0YxwSbkqeUPrvuArrdOa1W7tHRUbJZoCkmnWD5QcEXXLLfBZB7QL EEd0D5tuGI69vs0TKMEkdSREFZ9BW2Qq868vztoG3xkZarWUAtwiSn00+6QKAlc9ERvjPk+sWXq RNiKTJkEg86A4/ch6daqNXNChQ4ou+X7byA== X-Gm-Gg: AZuq6aIkI1Lg5rHadj2ek4+eCDluDzCLayzIkIYR6KK5rFdabxykD2V2liJ/dNh94XW RhMkauE633tW67BJxHKnug10QBeo+CrgY3reed4Ejn6i4H5aHi66laxDIncfMxohXSv4BZVYia9 AyO4MzUoji1C6OSfdUSWpWVWilZBMc8phWJk1qu4XUXhbcGePlIcMp/+mSEGPpTZATFkvzsm/+B GTD1rA/+A5kO7UOiiWjKTac8Rl1CHLR7sTs5OZ9lIF6LxfRuiThKZaILp1esASgulIU6kfW57Jy 5RylY5Z5 X-Received: by 2002:a17:907:3e0f:b0:b8f:ad6:db92 with SMTP id a640c23a62f3a-b8fc38fc532mr56734566b.3.1771028671113; Fri, 13 Feb 2026 16:24:31 -0800 (PST) MIME-Version: 1.0 References: <8039d3e65e099b6046a48209fd1c194b1493fd8d.camel@cybertec.at> <2d3a434fe195f2f06734f06a9d0dd0cbfa9b00e6.camel@cybertec.at> In-Reply-To: From: Durgamahesh Manne Date: Sat, 14 Feb 2026 05:54:19 +0530 X-Gm-Features: AZwV_Qi6LWsU9AN7tkwDzWBvo0N56AdP6vMWzeqNKt_DlgWvbaXIvUaz4YMUIYk Message-ID: Subject: Re: Fillfactor effectiveness on existing table To: Laurenz Albe Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000d42bab064abdbe31" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d42bab064abdbe31 Content-Type: text/plain; charset="UTF-8" Hi All updates are HOT as per my observation With one day bloat I see about 70 gb Actual size of table is around 10gb only I see strange behaviour even of completing repack activity for 14 and as well as for 16 in the log I think there was an issue at code side How to fix this 2026-02-14 00:14:31.662 UTC,"offer","offer",674993,"127.0.0.1:28840",698fb1a0.a4cb1,376,"idle",2026-02-13 23:20:00 UTC,67/0,0,ERROR,26000,"unnamed prepared statement does not exist",,,,,,,,,"e3d","client backend",,2064869707185898531 2026-02-14 00:14:31.792 UTC,"offer","offer",675945,"127.0.0.1:50690",698fb3f8.a5069,482,"ROLLBACK",2026-02-13 23:30:00 UTC,113/111425,3142683,LOG,00000,"temporary file: path ""base/pgsql_tmp/pgsql_tmp675945.44"", size 62053892",,,,,,"ROLLBACK",,,"e3d","client backend",,3749380189022910195 2026-02-14 00:14:32.849 UTC,"offer","offer",673259,"127.0.0.1:17360",698facf0.a45eb,842,"ROLLBACK",2026-02-13 23:00:00 UTC,65/168038,3142686,LOG,00000,"temporary file: path ""base/pgsql_tmp/pgsql_tmp673259.41"", size 64701020",,,,,,"ROLLBACK",,,"e3d","client backend",,3749380189022910195 2026-02-14 00:14:33.299 UTC,"offer","offer",675945,"127.0.0.1:50690",698fb3f8.a5069,483,"idle",2026-02-13 23:30:00 UTC,113/0,0,ERROR,26000,"unnamed prepared statement does not exist",,,,,,,,,"e3d","client backend",,2064869707185898531 2026-02-14 00:14:33.299 UTC,"offer","offer",675945,"127.0.0.1:50690",698fb3f8.a5069,484,"idle",2026-02-13 23:30:00 UTC,113/0,0,ERROR,26000,"unnamed prepared statement does not exist",,,,,,,,,"e3d","client backend",,2064869707185898531 2026-02-14 00:14:34.159 UTC,"offer","offer",674349,"127.0.0.1:61350",698fb074.a4a2d,396,"ROLLBACK",2026-02-13 23:15:00 UTC,49/153459,3142912,LOG,00000,"temporary file: path ""base/pgsql_tmp/pgsql_tmp674349.29"", size 44533064",,,,,,"ROLLBACK",,,"e3d","client backend",,3749380189022910195 Regards Durga Mahesh On Wed, 11 Feb, 2026, 14:23 Durgamahesh Manne, wrote: > > > On Wed, 11 Feb, 2026, 12:07 Laurenz Albe, > wrote: > >> On Wed, 2026-02-11 at 07:58 +0530, Durgamahesh Manne wrote: >> > Hi >> > @Laurenz Albe >> > offer=> SELECT relname AS table_name, n_tup_upd AS updates, >> n_tup_hot_upd AS hot_updates FROM pg_stat_all_tables WHERE relname = >> 'market'; >> > table_name | updates | hot_updates >> > market | 5997455764 | 3752865557 >> >> Did you read my e-mail? >> >> Yours, >> Laurenz Albe >> > > > Hi > > Yes I have read. Will check get back to you soon. On fly info given > earlier > > Regards > Durga Mahesh > >> --000000000000d42bab064abdbe31 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi

All updat= es are HOT as per my observation=C2=A0

With one day bloat I see about 70 gb=C2=A0
Actual size of table is around 10gb only=C2=A0

I see strange behaviour even of completing rep= ack activity for 14 and as well as for 16=C2=A0 in the log

I think there was an issue at code side= =C2=A0
How to fix this=C2=A0
=
2026-02-14 00:14:31.662 UTC,"offer",&= quot;offer",674993,"127.0.0.1:= 28840",698fb1a0.a4cb1,376,"idle",2026-02-13 23:20:00 UTC= ,67/0,0,ERROR,26000,"unnamed prepared statement does not exist",,= ,,,,,,,"e3d","client backend",,2064869707185898531 2026= -02-14 00:14:31.792 UTC,"offer","offer",675945,"127.0.0.1:50690",698fb3f8.a5069,4= 82,"ROLLBACK",2026-02-13 23:30:00 UTC,113/111425,3142683,LOG,0000= 0,"temporary file: path ""base/pgsql_tmp/pgsql_tmp675945.44&= quot;", size 62053892",,,,,,"ROLLBACK",,,"e3d"= ;,"client backend",,3749380189022910195 2026-02-14 00:14:32.849 U= TC,"offer","offer",673259,"127.0.0.1:17360",698facf0.a45eb,842,"ROLLBACK&quo= t;,2026-02-13 23:00:00 UTC,65/168038,3142686,LOG,00000,"temporary file= : path ""base/pgsql_tmp/pgsql_tmp673259.41"", size 6470= 1020",,,,,,"ROLLBACK",,,"e3d","client backend= ",,3749380189022910195 2026-02-14 00:14:33.299 UTC,"offer",&= quot;offer",675945,"127.0.0.1:= 50690",698fb3f8.a5069,483,"idle",2026-02-13 23:30:00 UTC= ,113/0,0,ERROR,26000,"unnamed prepared statement does not exist",= ,,,,,,,,"e3d","client backend",,2064869707185898531 202= 6-02-14 00:14:33.299 UTC,"offer","offer",675945,"<= a href=3D"http://127.0.0.1:50690">127.0.0.1:50690",698fb3f8.a5069,= 484,"idle",2026-02-13 23:30:00 UTC,113/0,0,ERROR,26000,"unna= med prepared statement does not exist",,,,,,,,,"e3d","c= lient backend",,2064869707185898531 2026-02-14 00:14:34.159 UTC,"= offer","offer",674349,"127.0.0.1:61350",698fb074.a4a2d,396,"ROLLBACK",2026-0= 2-13 23:15:00 UTC,49/153459,3142912,LOG,00000,"temporary file: path &q= uot;"base/pgsql_tmp/pgsql_tmp674349.29"", size 44533064"= ;,,,,,,"ROLLBACK",,,"e3d","client backend",,3= 749380189022910195

Regar= ds

Durga Mahesh

On Wed, 11 Feb, 2026, 14:23 Durgamahesh Manne, <maheshpostgres9@gmail.com> w= rote:

On Wed, = 11 Feb, 2026, 12:07 Laurenz Albe, <laurenz.albe@cybertec.at>= ; wrote:
On Wed, 2026-02-11 at 07:5= 8 +0530, Durgamahesh Manne wrote:
> Hi=C2=A0
> @Laurenz Albe=C2=A0
> offer=3D> SELECT relname AS table_name, n_tup_upd AS updates, n_tup= _hot_upd AS hot_updates FROM pg_stat_all_tables WHERE relname =3D 'mark= et';=C2=A0
> table_name | updates | hot_updates=C2=A0
> market | 5997455764 | 3752865557

Did you read my e-mail?

Yours,
Laurenz Albe


Hi

Yes I have read. Will check get back to you soon. On fly= info given earlier=C2=A0

Regards
Durga Mahesh
--000000000000d42bab064abdbe31--