Hypothetical Indexes for PostgreSQL
There's a lot of good ecosystem stuff around this:
HypoPG is a PostgreSQL extension adding support for hypothetical indexes.
An hypothetical -- or virtual -- index is an index that doesn't really exists, and thus doesn't cost CPU, disk or any resource to create. They're useful to know if specific indexes can increase performance for problematic queries, since you can know if PostgreSQL will use these indexes or not without having to spend resources to create them.
With one approach to using it here: https://www.percona.com/blog/2019/07/22/automatic-index-reco...
Fast web applications through dynamic, partially-stateful dataflow
Here's a database that does much better than this, it creates and fine-grainedly updates materialized views of the queries you're using: https://github.com/mit-pdos/noria
Here's an excellent interview with the creator: https://corecursive.com/030-rethinking-databases-with-jon-gj...
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
Postgres Indexes for Newbies
1 project | news.ycombinator.com | 19 Jan 2022
The SQLite Index Suggester
2 projects | news.ycombinator.com | 5 Jul 2022
PostgreSQL Explain Output Explained
2 projects | news.ycombinator.com | 28 May 2021
Postgres Invalid objects
1 project | reddit.com/r/PostgreSQL | 27 Apr 2022
1 project | reddit.com/r/PostgreSQL | 5 Nov 2021