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.94.2) (envelope-from ) id 1v1WJi-009Xra-E3 for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 20:42:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v1WJh-00FgfC-4U for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 20:42:21 +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.94.2) (envelope-from ) id 1v1WJg-00Fgey-Po for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 20:42:20 +0000 Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v1WJe-002FHW-2A for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 20:42:19 +0000 Received: by mail-lf1-x133.google.com with SMTP id 2adb3069b0e04-57bc9775989so139655e87.1 for ; Wed, 24 Sep 2025 13:42:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758746536; x=1759351336; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=HM8nZ62H1ro6+8fQ4UO1GMLPBzWTBklzCav77XgO3tU=; b=ksDsoJChnDvCgO6MNx6FW3p+eiGMBpx1ejzIQIw42VXF9L5xhfJ2GKIvImZy3HY8j3 usZbKDqewX/OTpDlAYzMaLs48sRdV5X9KgdFGokZC6zfIcPNcAVD6xWJC+H8Aoe/jR5v 1A1KVVaB/0TTuOb4wbRWrLFLUPmZIxubD8n+w3jKf9hwzc3B0Kuln0xQTMBzrQ5tQqMW R85G1XW4SGV7qM/YG5ZdcLb5BiIMnAQibCRWlNfPDVj4Ad+9vSQDRLJ7H6nsPdcFaMoQ 2m6d/A6zDwkrkrke1/4CM0RZ837+CLCSUHR2V/m3jGt5rNWuxz7DgxsSbn3dYjbgtvRr 8RBw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758746536; x=1759351336; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=HM8nZ62H1ro6+8fQ4UO1GMLPBzWTBklzCav77XgO3tU=; b=CRfaUTTPAMLxLQTejGWPiatxBpaf/B4v1hnjJiSOlLHWjTlXn+4OAf0jH2o8SdWJRh V0iwEXoEpvmEjz84gobu+0wM9fsKL4Lb0lksXz4J+9hSmGmk2uo8+aM2aANpoHGCY+yE vGG8eJMrQVtfl5oXmi5mTc4dmL0cagSC323IVCDi2Yvg7JjVsCO3ptERFwI7KNYZ/B9E VTzw1LhBUmTXmnHE0pxeFfCcDDVOnKlXzLL0xjWUUbrlUeX1k4ihfj7kFjwd0rQzfHCO lQKdFTTlAChNiU82NZbcRfBiheGKJzwewt+lkzt9KvRaTzYafLbHStX7HjJ65MOB0M2s kHIQ== X-Gm-Message-State: AOJu0Yyl434gtvwQ52gBP0WXL59uZkiP2elMxMnHqvJlzzLcoWPOTFnK a7pL8worINsKSugA8JSj+5bl2yeBhJ/C7xjUQsDeFpmFYh6Eg9e2i/jkdlt91QXLtDp8Sj0to5e P0oant2TkfqJcK+HtjVcRlx4Zfkne3I+8G5D3NgRL3PC7 X-Gm-Gg: ASbGncsKEqfDK5CEFKGd8xzgrvczCAcP5iR8Id63uAPUJ3RUuFfbZwkF2xWWzPA7lRr n3UBnnI3cR0eu804Ero4FxIDdc5n5XQTxyRoj0JOTjVUtv74xD/JWGgJCztoX/xttEkokDARy1b AeISxJnbqYRPb7lOW9n89Ti/h81bBkhgCMBPO+++a3GjmgjueH9BZo29t33wGXQCUQvA1m7opKk vQUu+lGBaLcdb/S/ZK/5Gs+VDcXbFAAq6+8zpaw8XqXwvALXkyI X-Google-Smtp-Source: AGHT+IEHQI2NgImCOikXjC70+Xm0NH20xZmyLHK/57EMEuNnPgmrfKkAIP4O1sAM+whd+I4N/Qny1LtX0xbiW+rDc8c= X-Received: by 2002:a05:6512:250d:b0:579:f5ec:ca56 with SMTP id 2adb3069b0e04-582d2f24ca9mr250730e87.41.1758746536256; Wed, 24 Sep 2025 13:42:16 -0700 (PDT) MIME-Version: 1.0 From: Siraj G Date: Thu, 25 Sep 2025 02:12:05 +0530 X-Gm-Features: AS18NWDkNON4u5TRnOl7BEpH_CZajeOVYbuERTuJQrTHYM8WhSVk_gig6kvlO1k Message-ID: Subject: Index rebuilding strategy To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000008b29cd063f9216e3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008b29cd063f9216e3 Content-Type: text/plain; charset="UTF-8" Hello Experts! What are the top pointers we should consider for index rebuild? Check its size, bloat estimate, heavy Updates/Deletes? Please highlight the best practices. Thanks Siraj --0000000000008b29cd063f9216e3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Experts!

What are the top pointer= s we should consider for index rebuild? Check its size,=C2=A0 bloat estimat= e, heavy Updates/Deletes?

Please=C2=A0highlight th= e best practices.

Thanks
Siraj
--0000000000008b29cd063f9216e3--