PostgreSQL andmebaasi jõudluse muutuste hindamine viimase 15 aasta jooksul.
Ryan Marcus, developer of the experimental Bao optimizer for PostgreSQL that uses machine learning for query execution optimization, published the results of performance testing of the built-in PostgreSQL query optimizer. The testing covered PostgreSQL branches from 8.4 (2009) to 16 (2023). Performance was measured using a collection called JOB (join order benchmark), which included over 100 complex queries […]
