2 ms·
Does postgres not have the ability to hint or force indexes? Long long time ago, I found that quite helpful with MySQL.
by sroussey 2y ago
Does postgres not have the ability to hint or force indexes?
Long long time ago, I found that quite helpful with MySQL.
- evanelias 2y agoNope, weirdly Postgres still doesn't have that ability even today.
- jitl 2y agoIt does not, and that fact is the #1 downside of Postgres. It is not predictable or controllable at scale, and comes with inherent risk because you cannot “lock into” a good query plan. I have been paged at 3 am a few times because Postgres decided it didn’t like a perfectly reasonable index anymore and wanted to try a full table scan instead :(
- benpacker 2y agoIt’s not in core, but there are multiple extensions that provide this functionality