I agree that our blog post lacks of details, here are some: - PostgreSQL 12 - 12 - No - We ran the test using the pg_prewarm [0] module, the difference was

I agree that our blog post lacks of details, here are some: - PostgreSQL 12 - 12 - No - We ran the test using the pg_prewarm [0] module, the difference was negligible Regarding the "toy" query, the reason we are showcasing this instead of other more complex queries is because this is a simple, easily reproducible benchmark. It provides a point of reference for performance figures. > Database benchmarking is pretty complex (and easy to bias), and most queries do not look like this toy one. I would say that benchmarking is very hard. We tried not to perform a biased benchmark by running something that is not time-series specific and which does not put us in advantage compared to what Postgres should do. The takeaway from this is that configuration is important and we should expose it. The next benchmark we do will have an associated repository so people can review our config and point non optimal items if any. [0]: https://www.postgresql.org/docs/9.4/pgprewarm.html https://www.postgresql.org/docs/9.4/pgprewarm.html