Hacker News with Generative AI: PostgreSQL

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

11 points by michelpp 1 day 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

164 points by spennant 3 days ago | 78 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

24 points by giulianopz 5 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 5 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 6 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 6 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 8 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 14 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 15 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 16 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 16 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 19 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 27 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 29 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 30 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 34 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 36 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 40 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 41 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 41 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 44 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 48 days ago | 54 comments

Microsoft open sources PostgreSQL extensions (theregister.com)
Analysis When Microsoft rolled out an open source extension stack for PostgreSQL to handle document-style data, it wasn't just taking aim at MongoDB – the dominant NoSQL player – but also blurring the lines between relational and non-relational databases, according to one expert.

Open Source, Databases, PostgreSQL, Microsoft

161 points by beardyw 49 days ago | 80 comments

PostgreSQL Best Practices (speakdatascience.com)
PostgreSQL (Postgres) is one of the most powerful and popular relational database management systems available today. Whether you’re a database administrator, developer, or DevOps engineer, following best practices ensures optimal performance, security, and maintainability of your database systems.

Databases, PostgreSQL, Best Practices, Data Management

72 points by lemonwaterlime 51 days ago | 45 comments

Scaling with PostgreSQL without boiling the ocean (shayon.dev)
“Postgres was great when we started but now that our service is being used heavily we are running into a lot of ‘weird’ issues”

Databases, PostgreSQL, Performance, Scaling

40 points by plaur782 51 days ago | 14 comments

Solving Postgres' Search Limitations (paradedb.com)
We recently completed one of our biggest engineering bets to date: migrating pg_search, a Postgres extension for full text search and analytics, to Postgres' block storage system. In doing so, pg_search is the first-ever extension1 to port an external file format to Postgres block storage.

Databases, PostgreSQL, Search, Open Source, Performance

7 points by philippemnoel 53 days ago | 0 comments

A New Postgres Block Storage Layout for Full Text Search (paradedb.com)

Database, PostgreSQL

13 points by craigkerstiens 58 days ago | 1 comments

A Rust procedural language handler for PostgreSQL (github.com/tcdi)
PL/Rust is a loadable procedural language that enables writing PostgreSQL functions in the Rust programming language.

Rust, PostgreSQL, Programming Languages, Databases

120 points by dgroshev 61 days ago | 21 comments

Doubling Down on Postgres Compatibility: YugabyteDB Levels Up with PG15 Features (yugabyte.com)
The latest release of YugabyteDB delivers 15 key PostgreSQL 15 features, providing an industry-first zero-downtime PostgreSQL upgrade and downgrade experience, giving customers a truly cloud-native PostgreSQL solution.

Databases, PostgreSQL, Cloud Computing, Open Source

12 points by 3littlefish 61 days ago | 1 comments

Mathesar – an intutive spreadsheet-like interface to Postgres data (github.com/mathesar-foundation)
Mathesar is an open source application that makes working with PostgreSQL databases both simple and powerful.

Open Source, Databases, PostgreSQL, User Interface, Data Analysis

323 points by gjvc 62 days ago | 80 comments