postgres

RSS

1
Training a 4B model to produce 81% faster query plans than Postgres rohanbansal.com
A 4‑billion‑parameter open‑weight LLM, fine‑tuned with supervised learning and a custom RL loop, learns to emit PostgreSQL join plans that cut query latency by 44.7 % on a 113‑query benchmark. The author built a low‑noise measurement harness, a GRPO‑style reward function, and ran off‑policy distillation from ~500 GPT‑6‑style trajectories, demonstrating that a modest model can outperform Postgres’…
Hacker News front pagerohanbansal.com5d51 minHN692143
2
Introducing TIN: full-text search for Postgres planetscale.com
PlanetScale’s TIN is a new PostgreSQL extension that implements a full‑text search index supporting Boolean, phrase, span, fuzzy, wildcard, regex, case/accent folding, COUNT(*) and BM25 top‑k queries. In a suite of benchmarks on an i7i.8xlarge EC2 instance (8 vCPU, 32 GB RAM), TIN built in 8 min 10 s (50.7 GB index) and outperformed ParadeDB, pg_textsearch and the built‑in GIN index by large marg…
PlanetScaleplanetscale.comEric Ridge6d15 minHN20175
3
The architecture of Neki planetscale.com
Neki is PlanetScale’s sharding layer for vanilla PostgreSQL that presents a single Postgres endpoint while routing queries across a fleet of Postgres instances. It does this with a set of tightly‑coupled components—Router, Sidecar, PostgresManager, Admin, Operator, and etcd‑backed Data Topology—each handling a specific piece of the scaling, failover, and query‑planning puzzle.
PlanetScaleplanetscale.comHarshit Gangal4d8 min
4
How a solo founder runs a five-continent tender platform on AlloyDB and MCP google.com
A solo founder runs a global tender platform using Google Cloud's AlloyDB for PostgreSQL and Model Context Protocol (MCP). This setup consolidated relational data, vector embeddings, and audit logs, reducing semantic search latency by 47x with ScaNN indexing and automating database operations.
Google Cloud Bloggoogle.comDavor Jerković5d4 minHN2
5
Introducing Lead: TIN-compatible full-text search for CI planetscale.com
Lead is a Postgres full‑text search extension compatible with TIN, intended for CI and testing environments. It offers the same SQL and TINQL features but runs as a full table scan, making it orders of magnitude slower, so it’s only practical for small datasets.
PlanetScaleplanetscale.comPatrick Reynolds5d2 min
6
Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026 clickhouse.com
The author recaps two Dutch conferences where they presented ClickHouse‑Postgres extensions and discussed PostgreSQL 19 monitoring enhancements. The post explains how pg_clickhouse provides transparent query push‑down to ClickHouse and how pg_stat_ch streams per‑query metrics, plus new logging defaults and system views in PG 19.
ClickHouseclickhouse.comGülçin Yıldırım Jelínek5d7 min
7
pgAssistant 3.8.0 : continuous improvement loop for Postgres postgresql.org
pgAssistant 3.8.0 expands from a tuning advisor to a continuous PostgreSQL improvement platform, adding a Collector that records historical workload and environment data. It lets teams run an Observe‑Diagnose‑Prioritize‑Plan‑Implement‑Measure loop, compare consecutive snapshots, and measure the impact of applied recommendations.
PostgreSQLpostgresql.orgpgAssistant dev team6d1 minrelease
8
How Meshtastic Metrics Exporter Turned Eight Prometheus Queries Into One with Tiger Data tigerdata.com
A Python exporter reads Meshtastic mesh telemetry from MQTT and writes it directly into a TimescaleDB‑enabled PostgreSQL instance, replacing a Prometheus setup that hit ~0.5 M series for 10 k nodes. The single database lets Grafana dashboards join node metadata with eight time‑series tables in one query, eliminates scrape‑budget limits, and uses native retention/compression (14‑day compression, 3…
Timescaletigerdata.comAndrew Stebbins6d6 min
9
Knowing When Your Composite Index Earns Its Write Cost tigerdata.com
This guide explains how to evaluate the trade-off of adding a composite index in PostgreSQL by quantifying its read benefits and write costs. It provides a method to measure the impact on ingest throughput and decide if the index earns its overhead based on your system's peak ingest ceiling.
Timescaletigerdata.comNanoHertz Communications4d8 min
10
September 2026 newsletter clickhouse.com
ClickHouse's September 2026 newsletter highlights the 26.8 release with features like pipelined SQL and custom HTTP handlers, alongside previews for On-Demand Compute and a PromQL-compatible TimeSeries engine. It also covers new Postgres integration tools and a cost-performance benchmark for cloud data warehouses.
ClickHouseclickhouse.comMark Needham5d7 min
11
pgAdmin 4 v9.18 Released postgresql.org
pgAdmin 4 v9.18 adds a VS‑Code‑style Object Explorer toggle, tightens CSP defaults, and patches five CVEs (auth bypass, argument/connection‑string injection, TOCTOU file write, LLM redirect, empty username import). It also fixes numerous UI bugs, schema‑diff regressions, and updates dependencies. Windows/macOS installers, Docker, RPM/DEB, and a Python wheel are shipped.
PostgreSQLpostgresql.orgpgAdmin Development Team5d4 minrelease
12
6 Lesser-Known Heroku CLI Commands You Probably Aren’t Using heroku.com
A short‑list of six Heroku CLI commands that can reduce UI‑driven context switches: exporting config vars, inspecting live DB queries, SSH‑like dyno access, running detached jobs, enabling shell autocomplete, and opening add‑on dashboards.
Herokuheroku.comAndy Smith27d6 min