Tech News
← Home  ·  All topics

Postgresql

21 GoKawiil briefs on this topic

PostgreSQL internals author Hironobu Suzuki seeks new international role

Hironobu Suzuki, author of the long-running documentation project 'The Internals of PostgreSQL,' has announced he is available for new work after recovering from a health-related stay in Japan. He says he is seeking PostgreSQL-related roles in Europe, the Southern Hemisphere or Southeast Asia, either with visa sponsorship or as remote digital-nomad work. Separately, his documentation project, first published in 2015 and translated into Chinese in 2019, now covers PostgreSQL through version 19-beta.

ZeBridge offers local PostgreSQL replicas synced via NATS for offline-first apps

ZeBridge is a new system that keeps a local PostgreSQL replica on each device, queues writes made offline, and syncs them through NATS once connectivity returns, with PostgreSQL remaining the final authority on conflicts. It targets multi-tenant B2B operational apps like fleets, depots and field teams rather than consumer apps, and offers a live demo plus a Docker Compose quickstart for testing.

Solo founder reports one year of Dioxus fullstack Rust in production, cites 90-minute CI builds

A solo SaaS founder has detailed a year of running Dioxus 0.7 fullstack Rust apps in production for products SeggWat and infra.page, both built on Cargo workspaces with PostgreSQL backends. The developer reports shared Rust types across server and client eliminate drift between backend and frontend, but notes release builds on GitHub-hosted runners take 90 minutes.

RFC 9562 allows UUIDv7 timestamps to drift from actual creation time

A blog post by Robert Alexander examines UUIDv7, the time-ordered UUID format, and argues that its commonly assumed properties—monotonic ordering, accurate embedded timestamps, and unguessability—are not strictly guaranteed. He cites RFC 9562 itself, which permits implementations to alter the timestamp field rather than deriving it strictly from the system clock, and notes Postgres documentation warning that extracted timestamps may not match actual generation time. According to the post, the only property UUIDv7 reliably provides is uniqueness and collision resistance.

PostgreSQL's recovery_prefetch feature found causing replication outages

A bug in PostgreSQL's recovery_prefetch feature has been tied to real-world production outages, including a case where a customer's physical standby server suffered replay lag of several hours. The issue stems from the prefetch code issuing unnecessary fadvise system calls even when a page was already available from a full-page image in the WAL, burning excessive CPU in kernel space. The underlying concern was flagged by PostgreSQL developer Stephen Frost in a February 2021 mailing list message, well before the feature shipped, but was not addressed at the time.

PostgreSQL 19 beta sees 8-10 major features reverted after review wave

Several significant features committed to the PostgreSQL 19 development branch have been pulled during the beta period, an unusually high number compared to past release cycles. A PostgreSQL developer involved in some of the affected patches says the reverts stemmed from a mix of factors, including architectural flaws and a surge of edge-case bug reports surfaced partly through LLM-assisted code review.

Munich revives open-source push, swaps VMware, Jira, Oracle for alternatives

Munich's chief digital officer Laura Dornheim announced at Open Source Summit Europe that the city is replacing proprietary infrastructure software with open-source alternatives, including moving from VMware to Proxmox, Jira and Confluence to OpenProject and XWiki, and Oracle databases to PostgreSQL. The city is not reviving its old LiMux Linux desktop project, which it abandoned over a decade ago for Windows.

PostgreSQL 19 release pushed to November, 8-10 features dropped

The PostgreSQL Global Development Group has delayed PostgreSQL 19 from its planned late September/October launch to around November 19, cutting between eight and ten planned features. EDB's Peter Eisentraut, a core PostgreSQL committer, said many of the dropped features had architectural flaws and that newly adopted LLM-assisted code review surfaced a long list of smaller edge-case defects that developers couldn't fix in time for beta.

CedarDB raises funding for database combining transaction and analytics processing

CedarDB, a Munich-based database startup spun out of Technical University of Munich research project Umbra, builds a database engine designed to handle both transactional and analytical workloads in one system. The company, led by cofounder and CEO Moritz Sichert, built CedarDB to be compatible with PostgreSQL to minimize switching costs for enterprise customers.

Benchmark finds local NVMe outperforms gp3 EBS on 3.3B-row Postgres workload

At POSETTE 2026, Sai Srirampur presented a benchmark comparing a 3.3-billion-row PostgreSQL workload running on baseline gp3 EBS storage versus local NVMe storage. The talk argued that common scaling symptoms—slow ingestion, inconsistent read latency, autovacuum falling behind, and slower checkpoints—often trace back to storage performance rather than Postgres itself, and proposed architecture patterns for running Postgres on local NVMe in production.

New header-only C library implements ClickHouse's native binary protocol

A developer has released ClickHouse C, a header-only client library written in C11 that decodes the ClickHouse Native wire format, including both the TCP-based Native Protocol and standalone Native Format blocks. The core header works as a pure block decoder with no TCP or compression dependencies, with optional add-on headers providing TCP, compression, codec, and I/O backend support.

UpGuard finds 16,000+ misconfigured Supabase databases leaking user data

Cyber risk firm UpGuard scanned around 300,000 domains using Supabase and found more than 16,000 databases with misconfigured access controls exposing readable tables. Over half contained personally identifiable information, with smaller subsets exposing plaintext passwords, authentication tokens, and in some cases credit card data. Specific examples cited include a US valet service exposing 100,000+ customer records, a Canadian immigration service leaking 884 plaintext passwords, and an African government consulate exposing 25,000 records.