Topic
Everything filed under PostgreSQL, newest first.
RSS · JSON · All topics
json vs jsonb in PostgreSQL: size and speed, measured
json vs jsonb in PostgreSQL 17 and 18, measured on six document shapes: when jsonb is 23% smaller or 41% larger, read speed, GIN indexes, and what jsonb changes in your data.
14 min · 3,132 words
Postgres 19 is late, and it's AI's fault
PostgreSQL committer Robert Haas explains why PostgreSQL 19 will likely slip to November or later: LLM-driven code review and bug hunting surfaced an unusual volume of defects in new features, forcing reverts and fixes, and he argues every developer will now need to raise their game.
4 min · 897 words
Radim Marek explains how PostgreSQL's TABLESAMPLE really samples: SYSTEM picks whole pages so rows come in bundles, BERNOULLI with REPEATABLE drifts after an UPDATE, and hashing a key gives a stable sample, plus when each approach fits.
12 min · 2,718 words
Introducing TIN: full-text search for Postgres
PlanetScale announces TIN (Text INdex), a GA full-text search extension for Postgres and Neki with boolean/phrase/span queries, fuzzy and regex matching, BM25 ranking, and transaction-correct updates—built to be fast while staying inside Postgres.
15 min · 3,349 words
Introducing chdb Postgres extension: High-performance imports from cloud storage
ClickHouse announces the chdb Postgres extension: fast imports and exports across cloud storage and formats, powered by the embedded ClickHouse engine and usable via COPY-style workflows.
7 min · 1,599 words