Demystifying Database Performance for Developers

• how-query-engines-work

  2 329 0.0 Kotlin

  This is the companion repository for the book How Query Engines Work.

I highly recommend "How Query Engines Work" by Andy Grove (author of the Apache Datafusion Query Engine + Apache Ballista Distributed scheduler)

It's written in Kotlin and is very intelligible + succinct (99 pages):

https://leanpub.com/how-query-engines-work

https://github.com/andygrove/how-query-engines-work

• ottertune

  3 1,123 10.0 Python

  Discontinued The automatic DBMS configuration tool

  

Does it work?

Seems it's a now a commercial enterprise that has sprung from a CMU DB group project. An old version's still on Github: https://github.com/cmu-db/ottertune

They also had Peloton, a "self-driving SQL database management system", that's a dead project now.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• pg_adviser

  1 28 0.0 C

  Postgres' index adviser

  

Shameless plug(s). To address both the problems you described, I have developed the following Postgres extensions.

Index Adviser can be used to automatically analyze your workload, and it will suggest the indexes that might help your queries perform better.

Postgres Plan Guarantee (under development) helps you generate+freeze a plan, and ensure that the Query Optimizer will never pick a different plan for your query.

Postgres Index Advisor: https://github.com/DrPostgres/pg_adviser

Postgres Plan Guarantee: https://github.com/DrPostgres/pg_plan_guarantee

• pg_plan_guarantee

  4 83 0.0 C

  Postgres Query Optimizer Extension that guarantees your desired plan will not change

  

Shameless plug(s). To address both the problems you described, I have developed the following Postgres extensions.

Index Adviser can be used to automatically analyze your workload, and it will suggest the indexes that might help your queries perform better.

Postgres Plan Guarantee (under development) helps you generate+freeze a plan, and ensure that the Query Optimizer will never pick a different plan for your query.

Postgres Index Advisor: https://github.com/DrPostgres/pg_adviser

Postgres Plan Guarantee: https://github.com/DrPostgres/pg_plan_guarantee

Suggest a related project