MIME-Version: 1.0
References: <87bjjv1v96.fsf@gmail.com> <CANzqJaAXhYwR6vHzm_DqnxmWk8QCYxEmhs_JeZ+w3F+rx09xSw@mail.gmail.com>
 <CAHncFmSsXwmLCKs-ySFWe=gjb=rSaSsVZQV6hJuDczhLixidqA@mail.gmail.com> <CAApHDvoszp3fhsJQ759SkpYpJsn8ZcLXB26oR0sxXV-EavWKfQ@mail.gmail.com>
In-Reply-To: <CAApHDvoszp3fhsJQ759SkpYpJsn8ZcLXB26oR0sxXV-EavWKfQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 18 Dec 2025 17:55:53 -0500
Message-ID: <CANzqJaCzMGpNhDfD2uZCidGVKFtfrGX1K+C0u1o6_MKeqMob-A@mail.gmail.com>
Subject: Re: Dealing with SeqScans when Time-based Partitions Cut Over
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000928132064641ddb6"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCzMGpNhDfD2uZCidGVKFtfrGX1K%2BC0u1o6_MKeqMob-A%40mail.gmail.com>
Precedence: bulk

--000000000000928132064641ddb6
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Dec 18, 2025 at 3:21=E2=80=AFPM David Rowley <dgrowleyml@gmail.com>=
 wrote:

> On Fri, 19 Dec 2025 at 08:55, Matthew Planchard <msplanchard@gmail.com>
> wrote:
> > > How about just force seqscan off when the table is created?
> > > ALTER TABLE <table_partition> SET (enable_seqscan  =3D off);
> >
> > I didn't know this could be set on the table level! Our partitions are
> > created by partman, but we have a nightly job that does maintenance
> > stuff that could go through and update this setting on future partition=
s
> > before they come into use. I'm always hesitant to mess
> > too much with the planner, but this might be the ticket.
>
> You thought correctly. There's no such reloption.
>

Ah well.  I should have known that would be too easy.

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

--000000000000928132064641ddb6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Dec 18, 2025 at 3:21=E2=80=AFPM D=
avid Rowley &lt;<a href=3D"mailto:dgrowleyml@gmail.com">dgrowleyml@gmail.co=
m</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex">On Fri, 19 Dec 2025 at 08:55,=
 Matthew Planchard &lt;<a href=3D"mailto:msplanchard@gmail.com" target=3D"_=
blank">msplanchard@gmail.com</a>&gt; wrote:<br>
&gt; &gt; How about just force seqscan off when the table is created?<br>
&gt; &gt; ALTER TABLE &lt;table_partition&gt; SET (enable_seqscan=C2=A0 =3D=
 off);<br>
&gt;<br>
&gt; I didn&#39;t know this could be set on the table level! Our partitions=
 are<br>
&gt; created by partman, but we have a nightly job that does maintenance<br=
>
&gt; stuff that could go through and update this setting on future partitio=
ns<br>
&gt; before they come into use. I&#39;m always hesitant to mess<br>
&gt; too much with the planner, but this might be the ticket.<br>
<br>
You thought correctly. There&#39;s no such reloption.<br></blockquote><div>=
<br></div><div>Ah well.=C2=A0 I should have known that would be too easy.</=
div><div><br></div></div><span class=3D"gmail_signature_prefix">-- </span><=
br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt=
;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive=
.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div=
>

--000000000000928132064641ddb6--