Tag: postgresql
All the articles with the tag "postgresql".
One index, 467x faster: reading a PostgreSQL B-tree from the inside
Five million rows, one customer, 54 ms with a sequential scan and 0.116 ms with a B-tree index. The EXPLAIN output line by line, the tree's real depth from pageinspect, what the index costs, and every command to repeat it.
Postgres vs MariaDB on two dedicated CPUs: the setup, the settings and every run
PostgreSQL 18 and MariaDB 12.3 behind the same Go service, loaded with k6 up to 3,200 users. Reads, writes, 20 million orders and a spike, with the machine sizes, the config files, the per-level tables and what a single run cannot tell you.
Ten Spring Boot speedups on one small app, with the commands and the numbers
An index found through pg_stat_statements, join fetch, JDBC batching that stays off with IDENTITY ids, a Caffeine cache, projections, open-in-view, keyset paging, parallel calls, gzip and a JDK AOT cache. Each one with the code, the command that measures it and the output from one laptop.
