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 with 10000 provisioned IOPS.  I restarted the RDS instance
in between each test.

Schema: https://pastebin.com/bZvTLYGa

psql 13.7: https://pastebin.com/QtHXJtxq
psql 14.6: https://pastebin.com/PfVbCPJp
psql 14.6 with enable_seqscan=OFF: https://pastebin.com/i0g2NfUh
psql 14.6 with enable_sort=OFF: https://pastebin.com/9v9SGunw

Thanks,
Arthur

Reply via email to