News for hackers. Stuff that matters.
Re:Show HN: InstantDB – A Modern Firebase by sroussey on Thursday August 22, 2024 @11:13PM (#41325926)
Does postgres not have the ability to hint or force indexes?

Long long time ago, I found that quite helpful with MySQL.

Re:Show HN: InstantDB – A Modern Firebase by evanelias on Thursday August 22, 2024 @11:43PM (#41326021)
Nope, weirdly Postgres still doesn't have that ability even today.
Re:Show HN: InstantDB – A Modern Firebase by jitl on Friday August 23, 2024 @02:20AM (#41326538)
It 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 :(
Re:Show HN: InstantDB – A Modern Firebase by benpacker on Friday August 23, 2024 @08:45PM (#41334517)
It’s not in core, but there are multiple extensions that provide this functionality