#PostGres

Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.

...or how to make Qwen learn query optimization via agentic reinforcement learning

Last week we released version 0.2 of pgrust. This release was all about performance. It’s 10x faster than the previous version of pgrust. On OLTP benchmarks, pgrust is 30% faster than Postgres, and on Clickbench, Clickhouse’s benchmark for analytical…

How we optimized Postgres LISTEN/NOTIFY-backed data streams at scale, achieving 60K writes per second with millisecond latency.

When workflow metadata and application data live in the same Postgres database, they can be updated in the same database transaction, which simplifies tough problems like workflow task idempotency and atomicity.

Enforce real-time limits on your Postgres query traffic to protect your database from runaway queries and unexpected load spikes.

How we built WAL-RUS, an open-source Rust-based Postgres backup tool that reduces virtual memory usage by over 70% compared to WAL-G while maintaining full compatibility.

Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.

Connect Claude or ChatGPT to your Postgres database. Start simple with MCP, see where it breaks for teams, and what you need next.

Large DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE.

PgDog is a connection pooler, load balancer, and sharding proxy for PostgreSQL. Scale Postgres horizontally without rewriting your application.

PostgreSQL in-database durable execution. Contribute to microsoft/pg_durable development by creating an account on GitHub.

Stream Postgres to Apache Iceberg on S3 via logical replication, queryable over the Postgres wire protocol. - viggy28/streambed

Postgres CDC into ClickHouse via Kafka + Debezium, MaterializedPostgreSQL, and ClickPipes — setup, schemas, monitoring SQL, and where each one breaks.

Discover Microsoft’s PostgreSQL strategy across upstream innovation, Azure services, developer tools, and community support.

Announcing Postgres storage on Vercel. Connect your projects to native storage solutions. Works with any frontend framework.

New to the Vercel dashboard: Vercel KV, Vercel Postgres, and Vercel Blob. Announcing serverless storage solutions available on Vercel.