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 1voxMT-00GHhi-0A for pgsql-general@arkaria.postgresql.org; Sun, 08 Feb 2026 05:29:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1voxMS-007d3s-06 for pgsql-general@arkaria.postgresql.org; Sun, 08 Feb 2026 05:29:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1voxMR-007d3k-20 for pgsql-general@lists.postgresql.org; Sun, 08 Feb 2026 05:29:31 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1voxMP-00000001cn5-0HRD for pgsql-general@lists.postgresql.org; Sun, 08 Feb 2026 05:29:30 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-669f0b0290fso1929241eaf.1 for ; Sat, 07 Feb 2026 21:29:28 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770528566; cv=none; d=google.com; s=arc-20240605; b=cPPkpDwVnmEQkU6derx/kq3wHNAEjOPFp26HOpaSdZqrHZAVrLb4tAmthwf6BGOocK L74jwbOKTTEDGKyw42ZdQbSfTNg2PWL7vbTm+mUOdwxYr9Au6qvr2z8B3jLAzluEt6P2 qmfezzzkiHDkl66XA/Y/DaLKItTeWM5mL5F8KzAS4JkbQ/WnUEspRTDjTVUUgq31Bcs3 oPzQhXmGWK2xkLgg2lSFWCUE6xofaoi4lszSCdk7T5C54dBBQzKfvLNYbPX6aEHYa4mt HntiFUbcIBlEpZMn/Q/ZsmXoH+tydDIAHa2Az1Qza0/4nq0kyUt3JMDdk5feadOTcNQE rLHA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :dkim-signature; bh=zpyK/E11hDf9XRFAVmY9D3w1DB4RF50bNy49eV3SXlo=; fh=U9Vkrj/8YXu+wNKP4ImG87p6jlJYRxuB/zicT9qNons=; b=SPWrS3WTwYdRPLRrflAl+Hlc3ISk5mon3gAbSBGAVzV74xf0e0CWyOmCP7EcsABF7g hy6jmEDyn30/ZMteayHI17trKI/wxEXuQKzZVM7PCTuAETvbSPbf0muOl0QCV8/D/JyI jZtfBJ/Pl06ha9kJVSOOlcVl5tExdmtQmW57ln1Dm8f/ZCvpkD0OGdnWXE3aTGADX5UB ZhU7OKT+QJVIfYZ+N6O7lY8OOsytshl4Ifey+AtJmBix8vfNI0K2nUG2+cr/snjVjiPo jnyH0YgRDOaQQDJMwc0kCLLp1sGWgnH1jEq4uaCXBqF8L7Wq+32FKKbZE7w9+Xk15Y79 DMrw==; 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=1770528566; x=1771133366; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=zpyK/E11hDf9XRFAVmY9D3w1DB4RF50bNy49eV3SXlo=; b=H5EWpIMmNvE8/SMjqBE9r/vbfxeQ9quQqgMkhVZqsYNhKl+Ghf8i96aG0TmDzv9pdr Bzz0PGiHGWXpJyClJKKgNzHxvCt+oODIRNsMtKRGYwIY5rVeKtZ3idGXT9nvCe0/71Y0 2HSVcO4EEH9dzUQHKMYW/5rYS1lUUpRpqMCwtGSmuM73lv0cTwSnJoPEbDFdRhUZKRUD teXwGgn0zJ3zOZshj+l9J5epVy/r9TOSw4cCPpRCuarbvuJ5AM/VSM2kEJeTPVfPFSDr PPtKHL3uS8I/NwqlLs9EZBXFqNQfxmAu0aPKMSRNC3hUSKIel69ha3NOFPw2dX3E84AJ SkCA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770528566; x=1771133366; h=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=zpyK/E11hDf9XRFAVmY9D3w1DB4RF50bNy49eV3SXlo=; b=wbsi2pPfz1+pMAFhyOTXnZ/KEoE/KYhJhdxrfHU5B79L8OWPSFgBmUJRwKeIkffeg4 DfH5wnbLaZS1YYgKGOqSdD4/krlZhkb+ujwBS5E3peSEKkKBSb5WHnLbp71ip4G1ThL5 C3wd0DVgtAQ6S9EX16G4QN5uImvMAYtYdIoVHZdLjClFxHm4v91bmZi2H7wbBGeYDKBe qqtyCKPQTpBVQJ82sXXK7qMYpJWvd5cVzgbQXmKm0AZNxq3FYatX4cxrUvFzHjOfqgJr qFzQUTa65lBs5gDQlJ51U8XAq5Ghek43g88muoKS3twGKJcdjvXEg/viHtisiEfWyKKC /UvA== X-Gm-Message-State: AOJu0YzJXXAn/PmKcTSTdhdhRQ7jlZo+T8UXJc11AyY2UvZ6HkJXYrmW C6UXAKSbvASK2kw8UK82yH85uLA0FywtTByYwih0BthygXxi5cOEIurv2WCN0DlYmCy+TcY13lD NzusHNBF7p7PHVY6bIb8TzAUV53GuNKo7ABvH X-Gm-Gg: AZuq6aLmDzhja/33R3vPwbs+p8/nd/fCX9d/VIj8gaJDYq4XOizC+zrX/ewSRM8goK+ dt+5cUUg8qa2Py2Lip2WOd9I42BFsixRSd46DSAPSbkF41xnrLmbAPWkYlHMD2nF9oBBwbN5y99 EQQLQVjyLr8zI/zdlxs3R1IhOmbH2/wd5ayKSfaCxklhjtWev+neKX5NTw7v8FXCKIp9c0UQRP8 DsWe2MvoeFRoE+KlWi03EyHo6f56E93v4ehM5TBdiW303MzYWS5pYvQ516iYxXMcnta49GHFsfk 7zwgzCM= X-Received: by 2002:a05:6820:220b:b0:664:86ce:df3f with SMTP id 006d021491bc7-66d0bea8a2fmr4386883eaf.51.1770528565858; Sat, 07 Feb 2026 21:29:25 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Sun, 8 Feb 2026 00:29:14 -0500 X-Gm-Features: AZwV_QgdOrncHfnRKZCrYdNUlxCnKn9GGUqdcmFrVwDlnYIPWwCNgeXKTNE-PKA Message-ID: Subject: Re: Table bloat threshold limit to trigger repack To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000003b979d064a494e9b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003b979d064a494e9b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, Feb 7, 2026 at 11:19=E2=80=AFPM Durgamahesh Manne 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! --0000000000003b979d064a494e9b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sat, Feb 7, 2026 at 11:19=E2=80=AFPM D= urgamahesh Manne <maheshpos= tgres9@gmail.com> wrote:
Hi

How much table bloat is= acceptable before it affects performance in PostgreSQL?=C2=A0

How big is the table? (For small tables= , it doesn't matter.) How active is it?=C2=A0 How frequently are record= s updated?

--
Death to <Redacted>, and butter sa= uce.
Don't boil me, I'm still alive.
<Redacted&= gt; lobster!
--0000000000003b979d064a494e9b--