~postgresweekly | Issue 597 - User, User, Who is the User? (7)

Hacking the Postgres Statistics Tables for Faster Queries — Postgres’s internal statistics drive query planning and index choices, but the process isn’t perfect. This practical post shows how to manually add extended statistics to teach Postgres about useful correlations — and how even a single CREATE STATISTICS can make a query 97x faster.

Fully Managed Postgres with Aiven for PostgreSQL® — Set up a fully managed Postgres database in 10 minutes and focus on your code – let Aiven do the heavy lifting.

Scaling Certificate Transparency with 100B+ Rows of Data — Merklemap is a service that aggregates together certificate transparency data for issued TLS certificates – here’s how they use Postgres for task of managing data spanning 20TB of storage and 100 billion rows.

Striping Postgres Data Volumes - A Free Lunch? — Depending on your usage patterns, yes, striping together cheap cloud volumes can yield significant throughput and latency benefits.

Reordering Expressions in SQL Queries for Performance — Techniques to speed up query execution, with a focus on rearranging conditions in filter expressions, JOINs, HAVING clauses, and similar constructs.

Doltgres Beta Launch: A Version Controlled SQL Database — Doltgres is a Go-powered Postgres-flavored variant of the Dolt SQL database that offers Git-style merging and forking in a Postgres-wire compatible form.

A Postgres Language Server for Your IDE — Most modern code editors support language servers for providing language-specific coding enhancements like auto-complete, syntax highlighting, and refactoring. Supabase has come up with such a server for Postgres too, offering linting, autocompletion, error highlighting and type-checking out of the box.