Hacker News with Generative AI: PostgreSQL

OpenAI: Scaling PostgreSQL to the Next Level (pixelstech.net)
At the PGConf.dev 2025 Global Developer Conference, Bohan Zhang from OpenAI shared OpenAI’s best practices with PostgreSQL, offering a glimpse into the database usage of one of the most prominent unicorn companies.
Database Management, PostgreSQL, AI Companies, OpenAI
15 points by thunderbong 1 hour ago | 0 comments
IDE for PostgreSQL in VS Code from Microsoft (microsoft.com)
We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL database management and development workflows.
PostgreSQL, Databases, Development Tools, Microsoft
4 points by tosh 15 hours ago | 0 comments
UUIDv7 Comes to PostgreSQL 18 (thenile.dev)
Databases, PostgreSQL, New Releases
10 points by code_reader 3 days ago | 0 comments
Pglocks.org (pglocks.org)
Databases, PostgreSQL, Performance
80 points by hnasr 5 days ago | 12 comments
Migrating from Postgres to CockroachDB (squarespace.com)
PostgreSQL is awesome, and here at Squarespace, we love it for the stable foundation it provides for ACID (Atomicity, Consistency, Isolation, and Durability) compliant, business-critical workloads.
Databases, CockroachDB, PostgreSQL, Migration
5 points by shenli3514 7 days ago | 2 comments
Pgwatch: PostgreSQL Monitoring Solution (github.com/cybertec-postgresql)
🔬PGWATCH: PostgreSQL metrics monitor/dashboard
Databases, PostgreSQL, Monitoring, Open Source, Tools
8 points by klaussilveira 10 days ago | 0 comments
Implementing State Machines in PostgreSQL (2017) (felixge.de)
Finite-state machine (FSM) is a wonderful model of computation that has many practical applications. One of my favorites is turning business logic into simple FSMs.
Databases, Programming, PostgreSQL
30 points by todsacerdoti 15 days ago | 6 comments
Pg-Schema-Diff – Diffing Postgres Schemas and Generating SQL Migrations (github.com/stripe)
Computes the diff(erences) between Postgres database schemas and generates the SQL required to get your database schema from point A to B with minimal downtime & locks. This enables you to take your database and migrate it to any desired schema defined in plain DDL.
Database Management, PostgreSQL, SQL, Software Development, DevOps
7 points by cube2222 15 days ago | 0 comments
PostgreSQL 18 Beta 1 Released (postgresql.org)
The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 18 is now available for download.
New Releases, Databases, PostgreSQL
10 points by jkatz05 15 days ago | 1 comments
Pg_parquet v0.4.0: Google Cloud Storage, HTTPS storage, and more (crunchydata.com)
What began as a hobby Rust project to explore the PostgreSQL extension ecosystem and the Parquet file format has grown into a handy component for folks integrating Postgres and Parquet into their data architecture. Today, we’re excited to release version 0.4 of pg_parquet.
Software, Data, Cloud Computing, PostgreSQL, Parquet
7 points by craigkerstiens 16 days ago | 0 comments
Another look into PostgreSQL CTE materialization and non-idempotent subqueries (shayon.dev)
A few days ago, I wrote about a surprising planner behavior with CTEs, DELETE, and LIMIT in PostgreSQL, a piece I hastily put together on a bus ride.
PostgreSQL, SQL, Database Management, Performance Optimization
5 points by craigkerstiens 19 days ago | 0 comments
AWS Blog on Postgres Long Fork Anomaly (Response to Jepsen Report) (amazon.com)
On April 29, 2025, Jepsen published a report about transaction visibility behavior in Amazon Relational Database Service (Amazon RDS) for PostgreSQL  Multi-AZ clusters.
Databases, PostgreSQL, Jepsen, Cloud Computing
18 points by talawahtech 19 days ago | 0 comments
A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING (shayon.dev)
I recently discovered an unexpected behavior in PostgreSQL involving a pattern of using a Common Table Expression (CTE) with DELETE ... RETURNING and LIMIT to process a batch of items from a queue-like table. What seemed straightforward turned out to have a surprising interaction with the query planner.
PostgreSQL, Database, SQL, Query Planning, Performance
57 points by namanyayg 19 days ago | 50 comments
Understanding transaction visibility in PostgreSQL clusters with read replicas (amazon.com)
On April 29, 2025, Jepsen published a report about transaction visibility behavior in Amazon Relational Database Service (Amazon RDS) for PostgreSQL  Multi-AZ clusters.
Databases, PostgreSQL, Amazon RDS, Cloud Computing
22 points by robmor 20 days ago | 1 comments
Jepsen: Amazon RDS for PostgreSQL 17.4 (jepsen.io)
Amazon RDS for PostgreSQL is an Amazon Web Services (AWS) service which provides managed instances of the PostgreSQL database. We show that Amazon RDS for PostgreSQL multi-AZ clusters violate Snapshot Isolation, the strongest consistency model supported across all endpoints. Healthy clusters occasionally allow Long Fork and other G-nonadjacent cycles. These phenomena occurred in every version tested, from 13.15 to 17.4. Amazon RDS for PostgreSQL may instead provide Parallel Snapshot Isolation.
Database, Cloud Computing, PostgreSQL, Consistency Models
608 points by aphyr 24 days ago | 146 comments
Partitioning a large table in PostgreSQL with Rails (aha.io)
Databases, Rails, PostgreSQL
9 points by FigurativeVoid 25 days ago | 0 comments
PgDog is a transaction pooler logical replication manager can shard PostgreSQL (github.com/pgdogdev)
PgDog is a transaction pooler and logical replication manager that can shard PostgreSQL.
Databases, PostgreSQL, Open Source, Software, Transaction Pooling
27 points by Bender 29 days ago | 0 comments
Logical Replication from Postgres to Iceberg (crunchydata.com)
Operational and analytical workloads have historically been handled by separate database systems, though they are starting to converge. We built Crunchy Data Warehouse to put PostgreSQL at the frontier of analytics systems, using modern technologies like Iceberg and a hybrid query engine.
PostgreSQL, Data Warehousing, Analytics, Iceberg
8 points by theanirudh 31 days ago | 1 comments
Memory Size Matters to PostgreSQL (pgdba.org)
Nowadays it’s not uncommon to deal with machines with hundreds of GB of RAM.
Databases, PostgreSQL, Performance
60 points by PaulHoule 36 days ago | 11 comments
Heroku migrated PostgreSQL databases to Amazon Aurora (amazon.com)
In this post, we discuss how Heroku migrated their multi-tenant PostgreSQL database fleet from self-managed PostgreSQL on Amazon Elastic Compute Cloud (Amazon EC2) to Amazon Aurora PostgreSQL-Compatible Edition.
Cloud Computing, Databases, PostgreSQL, Amazon Aurora, Heroku
6 points by mariuz 36 days ago | 0 comments
Hacking the Postgres wire protocol (pgdog.dev)
PgDog is a network proxy and it can see every byte sent between Postgres and the clients. It understands SQL and can infer where queries should go, without requiring changes to application code.
Security, Databases, PostgreSQL, Networking
229 points by levkk 38 days ago | 50 comments
Show HN: Chrondb – a PostgreSQL-compatible Git-backed database [video] (youtube.com)
Databases, PostgreSQL, Git, Open Source, Software
11 points by avelino 44 days ago | 0 comments
PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth) (vectorchord.ai)
You might have come across discussions or blog posts suggesting that PostgreSQL's built-in full-text search (FTS) struggles with performance compared to dedicated search engines or specialized extensions.
PostgreSQL, Full-Text Search, Databases, Performance, Optimization
427 points by VoVAllen 44 days ago | 85 comments
Show HN: Latitude.sh Databases – Simple PostgreSQL DBaaS on Bare Metal (latitude.sh)
Introducing the fully managed, high-performance PostgreSQL database solution designed for scalability, reliability, and simplicity.
Databases, PostgreSQL, Cloud Computing, Bare Metal
15 points by gabrielmouallem 47 days ago | 2 comments
Show HN: SQLite? Postgres? Use both with omni_SQLite (omnigres.org)
omni_sqlite is an extension that adds the capability to use SQLite databases as a first-class data type within Postgres. It uses expandable datum technique to ensure no additional serialization overhead for data in-flight.
Databases, PostgreSQL, SQLite, Software, Extensions
12 points by michelpp 53 days ago | 0 comments
Show HN: Cloud-Ready Postgres MCP Server (github.com/stuzero)
A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents.
Cloud Computing, Databases, AI, PostgreSQL
167 points by spennant 54 days ago | 79 comments
Postgres Extension Tutorial (github.com/IshaanAdarsh)
Welcome to the Postgres Extension Tutorial. This comprehensive tutorial is designed to provide a step-by-step guide to PostgreSQL extension development.
Databases, Tutorials, PostgreSQL
25 points by giulianopz 56 days ago | 0 comments
Show HN: Searchable encryption, SQL proxy for Postgres (cipherstash.com)
Following fast on the heels of last week’s Protect.js announcement, we’re excited to introduce version 2 of CipherStash Proxy, our no-code data-protection solution for PostgreSQL.
Security, Databases, Open Source, PostgreSQL
10 points by dandraper 56 days ago | 0 comments
PostgreSQL Lands Initial Support for IO_uring: "Can Be Considerably Faster" (phoronix.com)
As a very exciting improvement for the open-source PostgreSQL database server, it has merged initial support for making use of IO_uring on Linux servers for asynchronous I/O and can provide for some nice performance improvements.
PostgreSQL, Databases, Performance, Linux, Asynchronous I/O
11 points by pella 57 days ago | 0 comments
Sharding Pgvector (pgdog.dev)
If you find yourself working with embeddings, you’ve shopped around for a vector database. pgvector is a great option if you’re using Postgres already. Once you reach a certain scale (about a million arrays), building indices starts taking a long time. Some workarounds, like parallel workers, help, but you still need to fit the whole graph in memory.
Databases, PostgreSQL, Embeddings, Vector Databases
86 points by levkk 58 days ago | 10 comments