Daily edition · Databases
TILens turns technical updates into a focused daily brief: official releases, trusted reporting, and practitioner analysis, deduplicated and organized by topic.
Migrating full-text search from SQL Server to PostgreSQL can silently change results because the engines handle text, linguistics, and accents differently. This post shows how to reproduce SQL Server full-text search on…
Re-organize build scripts, add to shellcheck (#2380) * ansible: Delete ansible.cfg I noticed that ansible.cfg isn't used anywhere in the repo so can go away. * scripts: Move useful scripts into ebssurrogate/scripts,…
Re-organize build scripts, add to shellcheck (#2380) * ansible: Delete ansible.cfg I noticed that ansible.cfg isn't used anywhere in the repo so can go away. * scripts: Move useful scripts into ebssurrogate/scripts,…
Just in time for the PostgreSQL 19 betas, I'm excited to announce release 1.2 of pg_statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics. This…
In this article written for experienced PostgreSQL engineers and core developers, I want to describe how we tested one hypothesis — whether a shared hash table can be used to speed up parallel aggregation by hashing. A…
Back in February, I wrote about Hackorum, a forum style web view of the pg-hackers mailing list. If you missed that post, you can read it here first. It turns the mailing list into something that reads and navigates a…
On 6 August, the Postgres Summit US 2026 Program Committee met to finalize the schedule: Chelsea Dole Jonathan Hinds Jonathan Katz On 11 August, the San Francisco Bay Area PostgreSQL Meetup Group, organized by Katharine…
A banking customer relying on logical backups had developed several serious problems over time they could no longer ignore: A full backup took nearly two days to complete. This warehouse is the home to hundreds of…
Introduction The purpose of this blog post is to introduce pg_shmemviz, a new tool to visualize PostgreSQL shared memory. It follows the same approach as pg_walviz, bringing physical layout and byte level navigation to…
PostgreSQL's GSSAPI authentication relies on two server-wide settings: `krb_server_keyfile` points to a dedicated keytab file (never share the system one), and…
