Deepthi Sigireddi is Head of Databases at Supabase with over 25 years of experience in database development. She led the Vitess project from 2020-2025, delivering major features like reversible schema changes and distributed transactions, and previously worked on Multigres. She specializes in database scaling and sharding solutions for distributed systems.
PostgreSQL 19 experienced an unusually high number of feature reverts during beta—approximately 8 to 10 significant ones—due to a combination of factors: insufficient development time, architectural defects discovered through improved LLM-assisted code review, and reduced senior developer availability during the security vulnerability response period. The author suggests most issues were addressable with additional time and focus, though the community prioritized maintaining the release schedule.
Incarnator is a Python/Django fork of Takahē that implements a Mastodon-compatible ActivityPub server for microblogging. It adds numerous features including trending hashtags, polls, push notifications, relay support, and group actors, requiring Python 3.14+ and PostgreSQL 14+.
An analytics dashboard company reduced query time from 35 seconds to half a second by implementing daily rollups in PostgreSQL. The optimization works because their metrics are additive sums of daily totals, allowing pre-computed aggregations to replace repeated full scans across millions of events.
A Polyglot Conference built a website serving data through APIs written in 27 different programming languages, with each request displaying which language handled it. The site uses Elixir and Phoenix for the frontend, PostgreSQL for storage, and implements caching, timeouts, and prewarming to optimize performance across the diverse backend APIs.
BerryDB is an open-source macOS database client built natively in Swift and AppKit that supports PostgreSQL, MySQL, SQLite, MongoDB, Redis, DynamoDB, Elasticsearch, and Qdrant. It features ultra-fast cold starts under 1 second, efficient memory usage for large datasets, an AI SQL Copilot, and Apple Keychain security integration.
Christophe Pettus explains max_wal_senders, a PostgreSQL parameter that limits WAL sender processes for replication, backups, and logical subscriptions. Since PostgreSQL 12, WAL senders have their own connection pool separate from max_connections, preventing application connections from blocking replication. The parameter defaults to 10 and requires careful sizing to accommodate pg_basebackup, logical subscriptions, pg_receivewal, and disconnected clients.
Neki, a PostgreSQL sharding router, optimizes performance by avoiding unnecessary work when queries pass through it. Rather than parsing results into structured types like Vitess does, Neki keeps response data as raw protocol bytes, only decoding what's actually needed. This lazy, composable design reduces allocations and processing overhead at the cost of parsing flexibility.