60 stories tagged with #postgres, in publish-time order across the WeSearch catalog. Tag pages update as new stories ingest.
⌘ RSS feed for this tag → or search "Postgres"
PostgreSQL's MVCC is bad. So is everyone else's
The critics are right: PostgreSQL's MVCC bloats tables and amplifies writes. Oracle, InnoDB, SQL Server, MongoDB, LSM stores, and etcd answer the same four design questions differe…
After rewriting SQLite in Rust, Turso turns its sights on Postgres
Cloud database upstart wants one virtual machine core to power multiple SQL frontends…
AI-Powered Retrieval in PostgreSQL with Azure HorizonDB
Developers need flexible, efficient item searches by description. Using a Wikipedia movie dataset, I started with full-text search, then created embeddings...…
Show HN: Otlet – Local LLM inference "inside" Postgres
Local LLM inference next to your data. Contribute to joshmeek/otlet development by creating an account on GitHub.…
PGSimCity - How PostgreSQL Works
An explorable 3D city that shows how PostgreSQL actually works — backends, shared buffers, WAL, checkpoints, autovacuum and replication, all running live in your browser.…
Bruce Momjian: Postgres AI Workshop
AWS was kind enough to organize an AI workshop this week in Pittsburgh for their employees, and the Postgres committers and core team. The first day covered the basics of setting u…
SHRIDHAR KHANAL: The Right Way to Give a Third-Party DBA Access to Your PostgreSQL Database
Giving an external team access to your PostgreSQL database is one of those decisions that deserves a little thought. The easiest option is to hand over a superuser account, but it’…
Ahsan Hadi: Hybrid Search in PostgreSQL: BM25, Sparse Vectors, and Reciprocal Rank Fusion
In my previous blog on the pgEdge Vectorizer and RAG Server , I showed how to build a semantic search pipeline using dense vector embeddings. The RAG Server already did hybrid sear…
Postgres LISTEN/NOTIFY actually scales
How we optimized Postgres LISTEN/NOTIFY-backed data streams at scale, achieving 60K writes per second on a single Postgres server with millisecond-scale latency.…
Show HN: DeepSQL – A self-hostable AI DBA agent for Postgres and MySQL
Hi HN - I'm Venkat, founder of Stayflexi (YC), CMU CS grad and Ex-Oracle Query Engine team (patents in core databases) DeepSQL started as an internal tool to stop our own databases…
AI agents write PostgreSQL like Python
Field notes from a production review of an AI-written PostgreSQL backend: exception blocks as control flow, casts that turn bad requests into 500s, races on state-advancing updates…
Rethinking Databases for Humans and AI Agents
Databases Were Built for Engines. It’s Time to Build Them for Humans.…
Mike Stonebraker: Disagreeing with Google, Postgres and Future Problems [video]
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.…
Rebuilding Postgres Metrics on Self-Hosted VictoriaMetrics with Zero Downtime
How we rebuilt Xata's PostgreSQL branch metrics on a self-hosted VictoriaMetrics stack in six weeks, with zero user-visible downtime.…
PostgreSQL Connection Pooling Explained: How It Works and Why It Matters
Opening a new database connection for every query is one of the most expensive things your backend...…
Handling Graphs with SQL/PGQ in PostgreSQL
Fuzzy Text Search in PostgreSQL: How Trigrams Make Computers "Almost Right"
A deep dive into one of the most clever tricks in database engineering - explained so simply, your...…
Azure HorizonDB: Enterprise-Ready Postgres, Engineered for the AI Era
Affan Dar, Vice President of Engineering, PostgreSQL at MicrosoftCharles Feddersen, Partner Director of Program Management, PostgreSQL at Microsoft Today at...…
PostgreSQL 20000 Error: Causes and Solutions Complete Guide
PostgreSQL Error 20000: case_not_found — What It Means and How to Fix It PostgreSQL error...…
PostgreSQL CLI Setup
Getting Started with Vector Databases Using Amazon Aurora PostgreSQL + pgvector
Hello! I'm Satoshi Kaneyasu, DevOps engineer at Serverworks. In this article, I'll introduce the...…
Great Stack to Doesn't Work Bonus: SQL vs NoSQL: Which One in 2026?
The honest decision framework, not another flame war. The SQL vs NoSQL debate has been running...…
Three Ways to Set Up CDC from Postgres to ClickHouse
Postgres CDC into ClickHouse via Kafka + Debezium, MaterializedPostgreSQL, and ClickPipes — setup, schemas, monitoring SQL, and where each one breaks.…
Installing PostgreSQL on Arch Linux | Practical Setup Guide
Installing postgres on windows/mac is pretty simple, you just follow the steps on the installation...…
Show HN: MigraDiff v1.3.0 – PostgreSQL schema diff with AI migration explanation
Install pip install --upgrade migradiff What's New AI-Powered Migration Explanation (--explain) MigraDiff can now explain any migration in plain English — what each change does, w…
PostgreSQL tool that you wish ware not deprecated
UUID v4 vs UUID v7 — Lequel choisir pour PostgreSQL en 2026 ?
Si vous utilisez PostgreSQL, vous avez probablement déjà dû choisir entre une clé primaire BIGSERIAL...…
Great Stack to Doesn't Work Bonus: 10 PostgreSQL Features You Didn't Know Existed
Between episodes, here's something lighter. Still useful. Still PostgreSQL. You've used...…
PostgreSQL 08003 오류 원인과 해결 방법 완벽 가이드
08003 connection does not exist 는? PostgreSQL 에러 코드 08003은 클라이언트가 이미 존재하지 않는 데이터베이스 연결을 통해...…
3 Files Every AI-Assisted Project Needs Before You Write a Line of Code
Most developers think of project setup as: install dependencies, configure TypeScript, set up...…
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning ...…
Not All Open Source Is Equal: Choosing a PostgreSQL Operator for Kubernetes in 2026
Recent licensing and distribution changes (MinIO archived, Bitnami catalog reduced, Crunchy Data redistribution limits) reshape what "open source" means for Kubernetes Postgres ope…
Practical Docker 29.5.2 setup for a Java 25 / Spring Boot 4.0.6 / PostgreSQL backend project using a vide-coding approach
AI and data sovereignty in Postgres: An answer to the datacenter energy crisis
A billion AI agents walk into a power grid…
Database Index Selection: Why Basic Approaches Fall Short?
Introduction: The Unseen Costs of Indexes When we talk about database performance, indexes...…
Debo Data Studio – Visual ETL that compiles pipelines to a single SQL query
Contribute to Debo-et/Debo_data_studio development by creating an account on GitHub.…
1.4 Planner: Which Path to Take
By the time 1.3 ends, the rewriter has let the Query tree through. Views have been expanded, RLS...…
How to set up PostgreSQL permissions for AI coding tools (Cursor, Claude, Copilot)
Most developers I talk to connect Cursor or Claude directly to their databases using a full admin...…
PostgreSQL 02000 Error: Causes and Solutions Complete Guide
PostgreSQL Error 02000: No Data PostgreSQL SQLSTATE 02000 ("no data") occurs when a query...…
RSQL – High-Performance, Open Source PostgreSQL Client (Tauri v2, React, Rust)
A Tauri application for efficient and secure database management. - rust-dd/rsql…
HeidiSQL – Lightweight MariaDB, MySQL, SQL Server, PostgreSQL and SQLite Manager
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi and Lazarus/FreePascal - HeidiSQL/HeidiSQL…
Why shouldn’t I just have Claude code connect to Postgres production db for every data analysis task?
Why Postgres Lacks Transparent Data Encryption
Oracle, SQL Server, and MySQL all ship Transparent Data Encryption. Postgres doesn't... yet the mailing list threads go back to 2016. Here's the full history: five implementations,…
The "Stateful App Storage Trap": We overprovisioned our self-managed Postgres/Kafka volumes for a huge ingestion job, and now we’re stuck paying for empty space.
TrailBase 0.28: Fast, open, single-executable Firebase alternative - now w/ Postgres
TrailBase 0.28: Fast, open, single-executable Firebase alternative - now w/ Postgres
Shaun Thomas on "Why Postgres Lacks Transparent Data Encryption"
Built a tool to catch dangerous Postgres migrations before they hit production
Built a tool to catch dangerous Postgres migrations before they hit production
Cache Aware Scheduling Shows Nice Wins For AMD Zen 5 On PostgreSQL, Valkey, Network Performance
The long-in-development work on Cache Aware Scheduling looks like it will come to a head soon with it looking like Cache Aware Scheduling will land for Linux 7.2.…
5 gotchas I hit moving LLM logs from Postgres to ClickHouse
The problem I am building Spanlens, an open-source LLM observability platform. Every call...…
How Polymarket Scaled Their Data Stack with Postgres + ClickHouse
Prediction markets move fast — and so does their data. As Polymarket grew to billions in monthly...…
Christophe Pettus: All Your GUCs in a Row: cluster_name
cluster_name looks like a cosmetic label for process listings, but on a standby it silently becomes the name your primary uses to verify synchronous……
Shinya Kato: 5 PostgreSQL locking behaviors that trip people up
Introduction PostgreSQL uses MVCC (Multi-Version Concurrency Control) for concurrency...…
5 PostgreSQL locking behaviors that trip people up
Introduction PostgreSQL uses MVCC (Multi-Version Concurrency Control) for concurrency...…
How I Built a Programmatic SEO Site with 16,750 Pages Using FastAPI and PostgreSQL
A deep dive into building BSBFinder.com — a free Australian BSB number lookup tool — from data...…
Open-sourcing a distributed bot platform built on Elixir, NATS, and PostgreSQL
Transaction Hooks: A General Primitive for Post-Commit Side Effects (Case Study: Queuert)
The previous two posts in this series walked through how Queuert keeps job state atomic with your...…
Andrei Lepikhov: EXPLAIN Prettier, or Post-Processing Query Plans in Postgres
EXPLAIN output carries more noise than most analyses need. EXPLAIN Prettier is an open-source PL/pgSQL script that strips it systematically, with stable output across Postgres vers…
Cornelia Biacsics: Contributions for week 20, 2026
Contributions for week 20, 2026 | PGConf.dev 2026 took place from May 19-22 2026, organized by Gwen Shapira Jonathan Katz Kaiting Chen Magnus ……