About 1 results
Open links in new tab
why Postgres prefer seq scan to partial index with explicit where ...
Feb 22, 2019 · I have a simple query like select * from xxx where col is not null limit 10. I don't know why Postgres prefer seq scan which is much slower than partial index (I have analyzed …