Re: Dealing with SeqScans when Time-based Partitions Cut Over

On Thu, Dec 18, 2025 at 3:21 PM David Rowley <dgrowleyml(at)gmail(dot)com> wrote:

> On Fri, 19 Dec 2025 at 08:55, Matthew Planchard <msplanchard(at)gmail(dot)com>
> wrote:
> > > How about just force seqscan off when the table is created?
> > > ALTER TABLE <table_partition> SET (enable_seqscan = 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 partitions
> > 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.

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