Hacker News with Generative AI: PostgreSQL

Using Postgres pg_test_fsync tool for testing low latency writes (tanelpoder.com)
Here’s a useful tool for quickly testing whether a disk (or a cloud block store volume) is a good candidate for your database WAL/redo logs and any other files that require low latency writes. The pg_test_fsync tool is bundled with standard Postgres packages, so no extra installation is needed. You don’t actually have to use Postgres as your database, this tool’s output is universally valuable for any workload requiring fast writes.
Databases, Performance, Testing, PostgreSQL
40 points by mfiguiere 31 days ago | 16 comments
Show HN: PgDog – Shard Postgres without extensions (github.com/pgdogdev)
PgDog is a transaction pooler and logical replication manager that can shard PostgreSQL. Written in Rust, PgDog is fast, secure and can manage hundreds of databases and hundreds of thousands of connections.
Databases, Open Source, PostgreSQL, Rust
307 points by levkk 32 days ago | 80 comments
Big Problems From Big IN lists with Ruby on Rails and PostgreSQL (andyatkinson.com)
If you’ve created web apps with relational databases and ORMs like Active Record (part of Ruby on Rails), you’ve probably experienced database performance problems after a certain size of data and query volume.
PostgreSQL, Databases, Performance, Web Development
7 points by Ocha 35 days ago | 0 comments
Postgres IDE in VS Code (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, Database Management, Development Tools
1040 points by Dowwie 35 days ago | 406 comments
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
190 points by thunderbong 35 days ago | 139 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
6 points by tosh 36 days ago | 0 comments
Announcing a new IDE for PostgreSQL in VS Code (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.
Databases, VS Code, PostgreSQL, Development Tools
12 points by coffeemug 37 days ago | 4 comments
UUIDv7 Comes to PostgreSQL 18 (thenile.dev)
Databases, PostgreSQL, New Releases
10 points by code_reader 38 days ago | 0 comments
Pglocks.org (pglocks.org)
Databases, PostgreSQL, Performance
80 points by hnasr 41 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 43 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 45 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 50 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 50 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 50 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 51 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 54 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 55 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 55 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 55 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 59 days ago | 146 comments
Partitioning a large table in PostgreSQL with Rails (aha.io)
Databases, Rails, PostgreSQL
9 points by FigurativeVoid 60 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 64 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 66 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 71 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 71 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 73 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 80 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 80 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 82 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 88 days ago | 0 comments