Topic · 16 stories
16 stories tagged postgres on AI Tamer, newest first.
pgrust v0.4-beta adds the Gravity JIT engine and opens daily development, a month after ClickBench removed it. Dan Luu cites its Postgres bug reports.
incident.io's 6 October post says each on-call tick ran in a savepoint, so SKIP LOCKED workers piled up on MultiXact locks. A lease, no subtransactions, and one claimer per pod preceded a 3.5 times gain.
PlanetScale says TIN 1.0.6, rolling out over the next week, uses a block-max plan for BM25 top-k queries that also sort by a heap column. Stemming for 18 languages arrived in 1.0.4 and needs a rebuild.
Neon says the lakebase_tokenizer extension, packaged with Lakebase Search, stores synonyms and stop words in SQL tables. The post does not name a new plan or region.
PGX says pgx-bm25 1.0 is a PostgreSQL-licensed BM25 index for PostgreSQL 17 and 18. The index lives in the server's own pages, so it gets WAL, crash recovery, and VACUUM.
ParadeDB tagged v0.26.0 on 3 October 2026. The notes include vector pushdown for RRF queries and ORDER BY that can push a vector distance plus a tie-break column. The pull requests merged in July.
Neon's 2 October 2026 post adds POST /v1/embeddings on AI Gateway, with qwen3-embedding-0-6b at $0.02 and gte-large-en at $0.13 per million input tokens, for vectors stored in Lakebase Postgres.
A read replica lags its primary and is read-only. Code that treats it as the same database can read stale data, or find its queries cancelled mid-flight.
ClickHouse (Oct 2, 2026): Managed Postgres live wal-g backups use WALG_DIRECT_IO plus stripe-sized RAID0 NVMe reads to skip page-cache eviction. Vendor benches only; incremental still prototyping.
Supabase (Oct 2, 2026) is acquiring Turso. Supabase continues Postgres; Turso continues SQLite. Glauber Costa joins with Pekka Enberg and the Turso team to lead agentic infrastructure. No deal price is disclosed.
JVN#22475874 (2026-09-29): seven Pgpool-II CVEs; lead CVE-2026-92867 authenticated OOB write (CVSS 4.0 8.7 / 3.0 8.8)—process termination and arbitrary code execution. Fixed in 4.7.3, 4.6.8, 4.5.13, 4.4.18, 4.3.21.
Radim Marek (boringSQL, Sep 28) benches PostgreSQL 19beta4 core REPACK (CONCURRENTLY) vs pg_repack/pg_squeeze: WAL, disk, cluster-wide VACUUM hold-back, ~105M change ceiling, and MVCC caveats—author benches only.
Google Cloud AlloyDB “PostgreSQL for agents” (docs updated Sep 24, 2026) is Preview only: agents query live transactional data with isolation from core systems and can scale compute to zero when idle.
PgBouncer 1.26.0 (Sep 23, 2026) fixes CVE-2026-19888, CVE-2026-6668, and CVE-2026-6669 (DoS only: crash, infinite loop, unbounded login work; no RCE or CVSS). Also: pool_idle_timeout and query_wait_timeout; -R removed.
PlanetScale’s hot-shards post (Sep 28, 2026) walks multi-tenant AI SaaS through vertical scale, whale isolation, and online table-level Reshard on Neki—without taking the app offline. The post gives no Neki GA date beyond “since the launch of Neki.” The Slack Vitess analogy is third-party; Slack does not run on Neki. “Fastest cloud Postgres” is PlanetScale’s own claim.
Databricks GA’d Lakebase Search on AWS/Azure (blog 2026-09-28): lakebase_vector (ANN) + lakebase_text (BM25) in the same serverless Postgres OLTP—hybrid via RRF, no separate search cluster. VectorDBBench/Conexiom figures are vendor-reported.
