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 1v1XQ7-009jhB-71 for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 21:53:03 +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 1v1XQ5-00G1II-HS for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 21:53:01 +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.94.2) (envelope-from ) id 1v1XQ5-00G1I2-5I for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 21:53:01 +0000 Received: from mail-wm1-x344.google.com ([2a00:1450:4864:20::344]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v1XQ0-002hOj-24 for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 21:53:00 +0000 Received: by mail-wm1-x344.google.com with SMTP id 5b1f17b1804b1-46b7bf21fceso1583045e9.3 for ; Wed, 24 Sep 2025 14:52:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1758750777; x=1759355577; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=VCHRfAht9X7HZ9z4IeH3IXsJHdXJdOqx1rNONX+qhMY=; b=k/kdCNc9cYTNz2ZZuHoSuOC+I5mIwmUUtNk4xL6Eq1kwwCefzk3Iq0+3LdpvO+Y13f wx/yc6d9+jV7f8OpZnloqJomlXqCmCcZw0xetEy3nBU5beFtFuUBkTqNzxX5PHabxiAO i+9wDUw1ytMtPe7Jv9qPpjT+T0mXABoKO7lbR30zVk1vPsg1Vp1og7+3IfsZydwz2GWi ekSU6F+z2KJl7kDDufVTugWcfKNoXs42ItiKQ9WEgI/ocjDMdV93FSJIeJnhjsJLeDtW PtOGQbBwrTWNIqBwXsJYXsinibSrAO1eru5Ar5ZMRWmxB/MGWP8K/upYVNY+IGu017kL qvPQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758750777; x=1759355577; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=VCHRfAht9X7HZ9z4IeH3IXsJHdXJdOqx1rNONX+qhMY=; b=d3EOTN6km/3ZDcbf1veiCQjT5ck0vO23XKyd7ogswWp5ruFgltNxmlB6KSmO+jJUPM rr/3znwoZiDcfBYIrtfHesVCwLR0o5KWWaK9d5b9Bn+jFU8kUg/KqhbvUBgNOGohKWNA FGMa/z++isyQ2K0caBq0X89frYbZyFqVfDlrw9ucbm3EbIpI07yYsPpVo+OJY2inSMIc yopkq5WEiAmkjvFzSHqaiyYgZetALmjCOPrzXcvFEimj6mRMg/HiZWuQcjVU6ZgOfFMl hBHieH0nurJShzzT3sDwMTvEcyAswRCIwqNfhfs4e8wj5QngbknQ6qpuR50Sa4hjSGBs HpIA== X-Forwarded-Encrypted: i=1; AJvYcCUCyU/BagNbi/jV7o8dR3+UPXxs25axhtrOvOcOzBZKmvmn/sFirxurEJD2sAKLoAjuFqEOvrmaSWzNa1DK@lists.postgresql.org X-Gm-Message-State: AOJu0Yx61g6qd8HhCpAcNAR9ydQFs2kOhdzgdxzoiNc/SNkC/7o9iEEU beRZc94+x3CXbuI6xDzmo4zGxyM40KZZWnpP14nbD05eKMZHsmLFqzvnnn6GBo3pTSUMU+5nHr1 W/bvFlW/LFQ== X-Gm-Gg: ASbGncuTWSysSdcdxZs8rOrTxSf5b6t6ciWn683o9Saaj4GcjxyrSb0/s58VP6lqsm+ YwSewOQGhe7lc2sT5sdbDCeGMEICSmf/wpEYn4yf/uFRDAsllQy8cyHtsq8sp0NAJAeTf5jz44M U7QXrvCWtToWaJPFq+JqeP8sPzREN6mdOdPwxBcSst/O0lZDIYA0AMQbm9Qku+DrzIg8XOb3ce/ ESCSNZY94t22J6Elh7ReQQEq1SaV8MqFcunFIMMMRkTtmszJG03vsYFmemyN6krVG6OF//e0KxK 61YxngCaS94AMt3XqYUZT/mwECGiyIzEnqXYp15N/LEeIHMoc2KrKx5L3yZ+Dy2YelX95aSkNat ZxhoUXG5hIEus0ulETlEhrvVjfLNpZ5JyO+AP2V9Ersh0Tbyhaa7xCRM= X-Google-Smtp-Source: AGHT+IHL1hymK2O8XQdF73552NPlCjjVaoRxPY8RKpDoLjTAUMDuBSKKq5l0r5dmDQ2R0a59naaq3w== X-Received: by 2002:a05:600c:4e90:b0:468:6049:95da with SMTP id 5b1f17b1804b1-46e329fac2amr11153345e9.24.1758750776887; Wed, 24 Sep 2025 14:52:56 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:b3a7:5d5a:5d5c:3780:cfe0]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-46e2ab48b40sm46882705e9.19.2025.09.24.14.52.56 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Sep 2025 14:52:56 -0700 (PDT) Message-ID: <6ecd5409cdc639a8fd3225eb38e069cd1b03544e.camel@cybertec.at> Subject: Re: Index rebuilding strategy From: Laurenz Albe To: Siraj G , "pgsql-generallists.postgresql.org" Date: Wed, 24 Sep 2025 23:52:55 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-09-25 at 02:12 +0530, Siraj G wrote: > What are the top pointers we should consider for index rebuild? Check its= size,=C2=A0 bloat estimate, heavy Updates/Deletes? https://www.cybertec-postgresql.com/en/should-i-rebuild-my-postgresql-index= / Yours, Laurenz Albe