Disjunctions and sequential scans

2018-01-11 Thread Ronuk Raval
Hi there, This is likely me not understanding something, but I have a query that I would expect to be fast but PG insists on using a sequential scan. I've attached a minimized test case but I'll walk through the steps as well. I'm running PostgreSQL 10.1 using the standard ArchLinux packages,

Re: Odd Choice of seq scan

2022-12-01 Thread Ronuk Raval
On Thu, Dec 1, 2022 at 8:21 PM Justin Pryzby wrote: > Could you show explain analyze ? > > Maybe on both a well-behaving instance and a badly-beving instance. Apologies for barging into this thread with a potentially unrelated "me too" but here's a similar OR-causes-seqscan from 2018: