News for hackers. Stuff that matters.
Re:Improving Postgres text search speed by zasdffaa on Saturday August 13, 2022 @03:10AM (#32447601)
It's a failure of the optimiser. AS a DB guy (MSSQL, not postgres), there's always a risk of this, you always have to be aware of this, and don't assume. MSSQL's optimiser is pretty good but I've also seen slowdowns on plain queries after adding an index. Optimisers are complex and individual optimisation rules interact in odd and sometimes counterproductive ways. Also if your stats are not up-to-date, trouble is guaranteed.

There are no comments on this comment yet.