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 1vozUR-00Glv0-1N for pgsql-general@arkaria.postgresql.org; Sun, 08 Feb 2026 07:45:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vozUO-007kKa-2U for pgsql-general@arkaria.postgresql.org; Sun, 08 Feb 2026 07:45:52 +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 1vozUO-007kKR-0g for pgsql-general@lists.postgresql.org; Sun, 08 Feb 2026 07:45:52 +0000 Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vozUM-000000016IN-1Tyh for pgsql-general@lists.postgresql.org; Sun, 08 Feb 2026 07:45:51 +0000 Received: by mail-oo1-xc29.google.com with SMTP id 006d021491bc7-66f343a30ddso390615eaf.1 for ; Sat, 07 Feb 2026 23:45:50 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770536749; cv=none; d=google.com; s=arc-20240605; b=A63dcrajyDUP0Rt3Vyb86e15m5AT5q7v+XLrfhCVC+L0CsFydBr6WoQIB8RfbtK+IA His3+78AmGvKm9rynrqQtXRiZOxglPDSUTtWwJiFO96YHMz6uR5RI1jCsQPebz13Pn4N 0xFHlmtRBxhmU7VA+Ls42Xq2kZvDtOClqPW/mS8Md3V6Zkd23WpzIT/9ZYekCKOfn/9A RGYC8qz78si0ws9WuMGeuDrOKpdvUu28Du+LwHvAubtfBWHaLRw+2je4KGR10lUaKSNr moIl/xMEz78tEWlAI5ISb1XKCvFE1BRq+CLDI2lVWb9hJN3R6d+REF4iefQpsndkdz56 UEvg== 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=hfkHBW8PCKWa2mKDdJHZpZ2FzIvjM1kecdCxbV4Tnd4=; fh=896RIOnat1xZkO/70p2DEH4n7c/DHfSjM2pkXW7TWgM=; b=E10TRQRQ8KpLN+xcLNbDlQKr/t+9bxByhf4ovQR1oY9djquYQk5TVZV9kwz/tFoLGT S65HWnO4CMQ+LSvw3nkEIfQRNUq8W5TWpb0AVQTCj5vS0dLfIh0+RIq1Qoc4x3tN+fmu z2tdpQ9/bv32VEdjwqrER5g6Wq7nN3QrcPjGsvCqbe0R9ZvQ+wWV2b4uQadQCqCkk41B qAbTg0Xvc2BXW5A11vvbMFobp34CKz92s8b7bqaK8aivhs6sAVyL1FM5spx1j/APX6Pp BOyA9MdE+r48KNaeBkUkGNg5q+nM7MmOOGd5ax5tYpUuxPu0KXSmmW/XccLiJdZXBCiJ Xq4A==; 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=1770536749; x=1771141549; 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=hfkHBW8PCKWa2mKDdJHZpZ2FzIvjM1kecdCxbV4Tnd4=; b=Du3evKg0TSKHGJrJRpbnDYXi5anNI8N9EAdLLGeO7aX9EqDUcVAkRdaLle/fTsQ30p Fyw6AdOjKPgJ4ngLvbHNuw9H5rWoKqLTJc9T2/UG454cI3p7sEJm8vtodMplB6jAbfgg 5CDikKNTCMXNpDlchtrCbYkl3A2cU3bQ0qbvmN196xzdNVyEm+8HI7Nfm1pBZvuL6hL9 9Tu8paeUr9biwzTPhQJfOI4v4PXDTxHiSEcR7zfAv46AE0OR5Xk/hInTnHcc2U7eZzLO 1AD+bshnjPO0qdlW8Ju4/DtCfS0z4UHorGwOalz0UqWlp1RD5b3pBbl81n9zHXsYJVMd Nqcg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770536749; x=1771141549; 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=hfkHBW8PCKWa2mKDdJHZpZ2FzIvjM1kecdCxbV4Tnd4=; b=lhY21qRx926LoVpW3UAeuPYhswA2/p/LhnQYxUt5P8I3JoeBrm8YRtrd+RjZLeDVyo KITg3qwuzDUEMNPUQ/TAB45nq0JmrOa/oMrO2YA4B6xTXzOqnjyMtsqk9vuSTBVaSHDI fDwH5ijQykoxyFwAFMeo9YwPesYd9D8luLBTjf2NbnC835uHTwXjMUAv46sYYbj1Vg2r A0+sx8PlWUHoWdchX2fL+xc4p7CdmZgzPdvLKMvETxjyPawmJ9j2fUnehm9ry2TDJSmd 6QSfnR7KhcUWrzwCI3MCIK4tdToRr0oplX+erMXreefkmlW/abPHTNSCKm9qHrlXrXOH gjJg== X-Gm-Message-State: AOJu0YxDMvqBizERIaDMBNa85Hxt0CVf97GkL3DWncrAZzEl70lyHamv vwqZRwIUIg9tLNJStg2NCBQloJ+n0XA5p7vJAr9WYZ4/++Zc8HFfghZYn4Xo0Knw5GJULHuRB0U S6FDLqBKxiwOSi0V4KI2tr3UpQH2hZws= X-Gm-Gg: AZuq6aJXZRntb/QMzb2PqE8rTggwXuqzV1loriEfIvW3oVXF5gUH6PmhkYpWbCnJnj0 bcb1stniw5bw1uJClfDc8Uq2PjOxSjCMH5WG0tQSPK6XV64hVdtBlzK/D9L33xbSsryz9pd23qR k3ndwD1ZPpVfyREMsVf0bmQ9tcKyD7Zs9npdw/cRzpJS7Wg1jJfpHSb/vanbIneH5jszXXyqkD1 P/E2NjbKc9PA9UFDVClQG0AcLCeFR/OVWzg2UQXG1zgiLXYvz3G0RxmT23EjdNJal7GRg+Y X-Received: by 2002:a4a:e0d6:0:b0:66e:10ca:fcdf with SMTP id 006d021491bc7-66e10cafd83mr1822444eaf.47.1770536749391; Sat, 07 Feb 2026 23:45:49 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Sun, 8 Feb 2026 02:45:37 -0500 X-Gm-Features: AZwV_Qhck6hHRDPcfuYBiWVIRtT4SPxNgkRa7qVYnC7NYq8kzdC4doZadfCF-wc Message-ID: Subject: Re: Table bloat threshold limit to trigger repack To: Durgamahesh Manne Cc: pgsql-general Content-Type: multipart/alternative; boundary="00000000000002632c064a4b3648" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000002632c064a4b3648 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Feb 8, 2026 at 12:43=E2=80=AFAM Durgamahesh Manne wrote: > On Sun, 8 Feb, 2026, 10:59 Ron Johnson, wrote: > >> On Sat, Feb 7, 2026 at 11:19=E2=80=AFPM Durgamahesh Manne < >> maheshpostgres9@gmail.com> wrote: >> >>> Hi >>> >>> How much table bloat is acceptable before it affects performance in >>> PostgreSQL? >>> >> >> How big is the table? (For small tables, it doesn't matter.) How active >> is it? How frequently are records updated? >> >> -- >> Death to , and butter sauce. >> Don't boil me, I'm still alive. >> lobster! >> > > > Hi > > Table size 100gb > I use pgstattuple_approx to get Table bloat is about 16gb as of now since > after repack is done on 27th of January > Fillfactor already in place > It's very critical application with updates on non partitioned table > What did you set the fillfactor to? Have you minimized the number of indexes? (That lets HOT work better.) How long does it take to VACUUM the table? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000002632c064a4b3648 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sun, Feb 8, 2026 at 12:43=E2=80=AFAM D= urgamahesh Manne <maheshpos= tgres9@gmail.com> wrote:
O= n Sun, 8 Feb, 2026, 10:59 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Sat, Feb 7, 2026 at 11:19=E2=80=AFPM Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:
Hi
How much table bloat is accepta= ble before it affects performance in PostgreSQL?=C2=A0

How big is the table? (For small tables, it doe= sn't matter.) How active is it?=C2=A0 How frequently are records update= d?

--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!


Hi
<= div dir=3D"auto">
Table size 100gb
I use pgstattuple_approx to get Table bloat is about 16gb as of n= ow since after repack is done on 27th of January=C2=A0
Fillfactor already in place
It's very critica= l application with updates on non partitioned table=C2=A0

What did you set the fillfactor= =C2=A0to?
Have you minimized the number of indexes?=C2=A0 (That l= ets HOT work better.)
How long does it take to VACUUM the table?<= /div>

--
Death to <Reda= cted>, and butter sauce.
Don't boil me, I'm still alive.
=
<Redacted> lobster!
--00000000000002632c064a4b3648--