Hacker News new | ask | show | jobs
by postila 3026 days ago
This is one of the interesting optimizations that DBMS should do automatically but it doesn't.

https://github.com/NikolayS/postgres_dba -- this toolset includes a version of report (see report a1) which analyses all tables in your database and shows opportunities to optimize.