Hacker News with Generative AI: PostgreSQL

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
24 points by Bender 1 day 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 4 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 8 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 9 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 11 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 17 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 17 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 19 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 25 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 27 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 29 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 29 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 30 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 31 days ago | 10 comments
Why PostgreSQL needs a better API for alternative table engines? (orioledb.com)
For a long time now, PostgreSQL has had an extensible Index Access Method API (called AM), which has stood the test of time and enabled numerous robust extensions to provide their own index types. For example: rum, pgvector, bloom, zombodb and others. PostgreSQL 12 introduced the Table AM API, promising equivalent flexibility for table access methods.
Databases, PostgreSQL, API, Performance, Extensions
15 points by atombender 33 days ago | 3 comments
Introducting dba: The Autonomous AI Agent for Postgres (tembo.io)
We made an autonomous AI Agent that closes the gap between Postgres monitoring and software engineering. We invite you to join the waitlist to try it out.
Artificial Intelligence, Database Management, PostgreSQL, Software Engineering, Open Source
10 points by samaysharma 39 days ago | 1 comments
Debugging PostgreSQL More Easily (cybertec-postgresql.com)
PostgreSQL is the foundation for thousands and thousands of applications. The system has long proven its worth and is operating reliably. However, the question people often ask is: What is the best way to actually debug a database application?
PostgreSQL, Databases, Debugging, Software Development
63 points by amalinovic 39 days ago | 18 comments
Selective async commits in PostgreSQL – balancing durability and performance (shayon.dev)
I was recently looking into some workloads that generate a lot of I/O and CPU contention on some very high-write code paths and came across synchronous_commit (https://www.postgresql.org/docs/current/wal-async-commit.html). It can be very tempting to turn this off globally because the performance gains in terms of I/O, CPU, and TPS (transactions per second) are very hard to overlook. I noticed I/O completely gone, CPU down 20% (at peak), and a 30% increase in TPS.
Database, Performance, PostgreSQL
109 points by shayonj 40 days ago | 37 comments
Life Altering PostgreSQL Patterns (mccue.dev)
Believe it or not, I don't think that title is clickbait.
PostgreSQL, Databases, Programming, Development
26 points by thunderbong 41 days ago | 11 comments
Xata Agent: AI agent expert in PostgreSQL (github.com/xataio)
Xata Agent is an open source agent that monitors your database, finds root causes of issues, and suggests fixes and improvements. It's like having a new SRE hire in your team, one with extensive experience in Postgres.
PostgreSQL, AI, Open Source, Database Monitoring, SRE
101 points by todsacerdoti 43 days ago | 19 comments
Postgres Just Cracked the Top Fastest Databases for Analytics (mooncake.dev)
TLDR: We spent a few months optimizing PostgreSQL and made it to the Top 10 on ClickBench, a benchmark typically dominated by specialized analytics databases.
Databases, Performance, Analytics, PostgreSQL
378 points by moonikakiss 51 days ago | 120 comments
The Internals of PostgreSQL (interdb.jp)
PostgreSQL is a well-designed, open-source multi-purpose relational database system which is widely used throughout the world.
Databases, Open Source, PostgreSQL
194 points by stevenmh 54 days ago | 40 comments
BM25 in PostgreSQL (vectorchord.ai)
We’re excited to share something special with you: VectorChord-BM25, a new extension designed to make PostgreSQL’s full-text search even better. Whether you’re building a small app or managing a large-scale system, this tool brings advanced BM25 scoring and ranking right into PostgreSQL, making your searches smarter and faster.
PostgreSQL, Databases, Search, Full-Text Search, Open Source
139 points by gaocegege 54 days ago | 31 comments
Vector Search at 10k QPS in PostgreSQL (vectorchord.ai)
VectorChord is a PostgreSQL extension designed for scalable, high-performance, and disk-efficient vector similarity search, and serves as the successor to pgvecto.rs. In our previous blog post, we showed that with just $250 per month, VectorChord achieved 131 QPS with 0.95 precision on 100 million vectors—demonstrating impressive cost-effective performance for large-scale vector search.
PostgreSQL, Vector Search, Databases, Performance, Open Source
10 points by gaocegege 58 days ago | 2 comments
VectorChord-BM25: PostgreSQL Search with BM25 – 3x Faster Than Elasticsearch (vectorchord.ai)
We’re excited to share something special with you: VectorChord-BM25, a new extension designed to make PostgreSQL’s full-text search even better. Whether you’re building a small app or managing a large-scale system, this tool brings advanced BM25 scoring and ranking right into PostgreSQL, making your searches smarter and faster.
PostgreSQL, Search, Performance, Open Source, Databases
5 points by gaocegege 60 days ago | 0 comments
Critical PostgreSQL bug tied to zero-day attack on US Treasury (theregister.com)
A high-severity SQL injection bug in the PostgreSQL interactive tool was exploited alongside the zero-day used to break into the US Treasury in December, researchers say.
Cybersecurity, PostgreSQL, Zero-Day Exploits, US Treasury
6 points by whalesalad 64 days ago | 1 comments
Reliably replicating data between Postgres and ClickHouse (benjaminwootton.com)
In this series of articles we are going to demonstrate how to reliably replicate data from PostgreSQL to ClickHouse.
Databases, PostgreSQL, ClickHouse, Data Replication
97 points by saisrirampur 65 days ago | 42 comments
PostgreSQL Lands Self-Join Elimination Optimization (phoronix.com)
More than seven years in the making, merged yesterday for PostgreSQL is a self-join elimination "SJE" feature as a performance optimization for some queries.
Databases, PostgreSQL, Performance Optimization
3 points by ksec 66 days ago | 0 comments
Representing Graphs in PostgreSQL (richard-towers.com)
Let’s say we’ve got some graph-like data, such as a social network.
Databases, PostgreSQL, Graphs
193 points by gsky 68 days ago | 77 comments
PgAssistant: OSS tool to help devs understand and optimize PG performance (github.com/nexsol-technologies)
PgAssistant is an open-source tool designed to help developers understand and optimize their PostgreSQL database performance.
PostgreSQL, Open Source, Database Optimization, Developer Tools, Performance Optimization
253 points by justinclift 73 days ago | 54 comments