World class PostgreSQL extentions

[xluffy]

• pg_squeeze: https://github.com/cybertec-postgresql/pg_squeeze or https://reorg.github.io/pg_repack/

PostgreSQL extension that removes unused space from a table and optionally sorts tuples according to particular index (as if CLUSTER command was executed concurrently with regular reads / writes)

• pg_qualstats: https://github.com/powa-team/pg_qualstats

pg_qualstats is a PostgreSQL extension keeping statistics on predicates found in WHERE statements and JOIN clauses. This is useful if you want to be able to analyze what are the most-often executed quals (predicates) on your database.

• auto_explain: https://www.postgresql.org/docs/current/auto-explain.html

The Postgres auto_explain module will log execution plans of qualifying statements at the time of their execution.

• pg_timetable: https://github.com/cybertec-postgresql/pg_timetable

Job scheduling is one of the most important topics in modern database management. In the PostgreSQL ecosystem, pgAgent and pg_cron have become quite popular. However, both tools have a fair number of limitations. That’s why we decided to release our own solution: introducing pg_timetable, the next-generation PostgreSQL job scheduler.

• pg_show_plans: https://github.com/cybertec-postgresql/pg_show_plans

PostgreSQL extension that shows query plans of all the currently running SQL statements.

• hypopg: https://github.com/HypoPG/hypopg

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.

• pg_bm25: lastic-Quality Full Text Search Inside Postgres https://docs.paradedb.com/blog/introducing_bm25

• PGroonga - PGroonga provides a new index access method that uses Groonga allowing super fast full text search feature against all languages. ref:

• https://www.enterprisedb.com/docs/pg_extensions/

• https://docs.crunchybridge.com/extensions-and-languages