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 1vXGaO-005wB6-2G for pgsql-general@arkaria.postgresql.org; Sun, 21 Dec 2025 10:22:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vXGaN-00Bcrt-1H for pgsql-general@arkaria.postgresql.org; Sun, 21 Dec 2025 10:22:48 +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 1vXGaM-00Bcna-2q for pgsql-general@lists.postgresql.org; Sun, 21 Dec 2025 10:22:47 +0000 Received: from mail.hjp.at ([212.17.106.138] helo=rorschach.hjp.at) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vXGaK-001tZ7-2j for pgsql-general@lists.postgresql.org; Sun, 21 Dec 2025 10:22:46 +0000 Received: by rorschach.hjp.at (Postfix, from userid 1000) id 512CE456F3; Sun, 21 Dec 2025 11:22:44 +0100 (CET) Date: Sun, 21 Dec 2025 11:22:44 +0100 From: "Peter J. Holzer" To: pgsql-general@lists.postgresql.org Subject: Re: Dealing with SeqScans when Time-based Partitions Cut Over Message-ID: Mail-Followup-To: pgsql-general@lists.postgresql.org References: <875xa31v2x.fsf@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="jjty5zh3rlnp7mff" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --jjty5zh3rlnp7mff Content-Type: text/plain; protected-headers=v1; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Subject: Re: Dealing with SeqScans when Time-based Partitions Cut Over MIME-Version: 1.0 On 2025-12-21 10:49:08 +0100, Peter J. Holzer wrote: > Since nobody seems to have an idea how to prevent the seqscans Ah, sorry. I didn't see that there were two (almost?) identical messages. There have been replies to the other one. hjp --=20 _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" --jjty5zh3rlnp7mff Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmlHymsACgkQ8g5IURL+ KF3fXhAArzbfeo+JnwXQoExfdpsz7A6aHsyVgSpXPWeHVctnqcJ+1l5Wm6hfgeHQ gfbfPy75oFCmLIKI/cUPvy/QN4hICFg204eCpzfEJXurRDeNTvZg850E15QuRls1 7vh3qCZirhetkgtGBWqs+lqbKdMaRUdB9kZC+MPllIXzh+9mJaQhUbo6M8EEdfAn qxBUsYKHtx6kNh4kOtZaOAYhjzJihf50Znfgcei/f5S8fpoJz7sRJTh2OX6zH5oR v+F/wKcTKTLv9QXQlIo4xd5yziooNP+0JqSRVS8rtyC3AqeqH4rvml+Z1LsKFXvI af/0YcIBmadI3BGQ5LywS4JX1Am4XnL72Gt/06SaBZ0tkatV3z/gFhQcHo3SZlZ5 LdjBL0nXIO91ptrqKODdf3hAv9T7O1UD7JkA8b7j1qVtNKKquIy5HiSAdlaclN5k 6DGWODszqnau9RzSLNiWnJeTD+UfBgiXv/EBxFWaw/zMiSkwb+ncHhsLXWIvNlI+ YIfBmQg/Fx3sAIDTfeIFjYM+WPttlo5WuB6+GIVxQEaaY+dtal/joMe9kd92ZD56 JvctfKHYsgMfUMEuFHc5KnMF4rO18YTcFS+hdAE4KVyEQ3H3dgdRqIDLvSlG3aFj pZMAF+5E7tZ3f1zhyjf+VSv2q7TeizcVYZoZrVk726B0chSMf9w= =DrVY -----END PGP SIGNATURE----- --jjty5zh3rlnp7mff--