On Fri, 19 Dec 2025 at 08:55, Matthew Planchard <[email protected]> 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. David
