News for hackers. Stuff that matters.
Re:Working around a case where the Postgres planner is “not ... by infogulch on Monday August 02, 2021 @04:14PM (#28042012)
SQLite has a nice solution to this problem: you can pin queries to use specific plans. By strategically controlling when statistics are redone, you can optimize a database for a specific set of queries. This does have the downside that it doesn't react to changes dynamically, but that is a good tradeoff in many circumstances.

There are no comments on this comment yet.