Re: Sequential scan faster than index

2023-02-21 Thread David Rowley
On Tue, 21 Feb 2023 at 22:30, Arthur Ramsey wrote: > > I'm trying to figure out why a sequential scan is out performing. I've tried > psql 13.7, psql14.6 and REINDEX. The REINDEX didn't help. This is on an RDS > instance that's a db.m5.large (2 * vCPU, 8 GB memory) with 200 storage on io1 >

Re: Sequential scan faster than index

2023-02-21 Thread Luca Ferrari
On Tue, Feb 21, 2023 at 10:30 AM Arthur Ramsey wrote: > > I'm trying to figure out why a sequential scan is out performing. I've tried > psql 13.7, psql14.6 and REINDEX. The REINDEX didn't help. This is on an RDS > instance that's a db.m5.large (2 * vCPU, 8 GB memory) with 200 storage on io1