Following a previous mistake, I find subqueries can beat CTE performance, but are still worse for the disk

Comparison of aggregation function speed, on the database and in a host language

EdgeDB is a layer above Postgres, as it uses it as the underlying engine. How can we harness the power of Postgres through this interface?

Diving into PostgreSQL query plans to improve our tooling