Hacker News with Generative AI: Postgres

Xata: Postgres at scale, with copy-on-write branching and anonymization (xata.io)
Relaunching Xata as "Postgres at scale". A Postgres platform with Copy-on-Write branching, data masking, and separation of storage from compute.
Databases, Postgres, Data Management, Cloud Computing, Security
45 points by mebcitto 6 days ago | 16 comments
The fastest Postgres inserts (hatchet.run)
At Hatchet, we spent the past half year running hundreds of benchmarks against different Postgres configurations. We set out with a simple question: at what scale does Postgres break?
Database Optimization, Postgres, Performance, Benchmarking
59 points by abelanger 7 days ago | 25 comments
Postgres with data branching and PII anonymization (xata.io)
Relaunching Xata as "Postgres at scale". A Postgres platform with Copy-on-Write branching, data masking, and separation of storage from compute.
Postgres, Databases, Data Management, Anonymization, Cloud Computing
13 points by simonklee 8 days ago | 4 comments
Migrating to Postgres (usemotion.com)
Since early 2022, Motion was on CockroachDB. Cockroach has many qualities going for it: effortless horizontal scaling, especially when dealing with multi-region set ups, extremely high availability, and a SQL-compatible interface.
Databases, Postgres, CockroachDB
241 points by shenli3514 9 days ago | 274 comments
Simple Agent API: A Minimal Setup for Serving Agents with FastAPI and Postgres (github.com/agno-agi)
A minimal, open-source setup for serving Agents using FastAPI and Postgres. Built for speed, clarity, and dev happiness.
FastAPI, Postgres, Open Source, Agents, API
10 points by bediashpreet 12 days ago | 0 comments
Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O (pganalyze.com)
With the Postgres 18 Beta 1 release this week a multi-year effort, and significant architectural shift in Postgres is taking shape: Asynchronous I/O (AIO). These capabilities are still under active development, but they represent a fundamental change in how Postgres handles I/O, offering the potential for significant performance gains, particularly in cloud environments where latency is often the bottleneck.
Databases, Postgres, Performance, I/O, Cloud Computing
572 points by lfittl 16 days ago | 154 comments
(All) Databases Are Just Files. Postgres Too (tselai.com)
Dear reader: If you’re feeling an urge to comment solely based on the title, just be warned that too many have done so already.
Databases, Postgres, Data Storage
6 points by mooreds 33 days ago | 0 comments
Vertical Sharding Sucks (pgdog.dev)
Vertical sharding, sometimes called functional sharding, takes tables out of your main database and puts them somewhere else. Most of the time, it’s another Postgres database. This reduces load on the main DB and gives your app some breathing room to grow.
Database Design, Performance Optimization, Scaling, Postgres
20 points by samokhvalov 42 days ago | 13 comments
Show HN: AI-Driven Index Tuning With Postgres MCP Server (github.com/crystaldba)
Postgres Pro is an open source Model Context Protocol (MCP) server built to support you and your AI agents throughout the entire development process—from initial coding, through testing and deployment, and to production tuning and maintenance.
AI, Postgres, Database Tuning, Open Source, Software
11 points by jssmith 44 days ago | 4 comments
Postgres Language Server: Initial Release (github.com/supabase-community)
Postgres, Language Servers, Open Source, Databases
362 points by steinroe 55 days ago | 52 comments
Postgres to ClickHouse: Data Modeling Tips V2 (clickhouse.com)
It is becoming increasingly common for customers to use Postgres and ClickHouse together, with Postgres powering transactional workloads and ClickHouse powering analytics.
Databases, Data Modeling, ClickHouse, Postgres
3 points by saisrirampur 67 days ago | 0 comments
Making Postgres scale (pgdog.dev)
Postgres scales. No other two words that I’ve ever heard of, produced more controversy. At least in the circles I hang out in, in the company basement where infrastructure elves make the Rails app go brrr. A lot of people believe, against all odds, and marketing campaigns by Big NoSQL, that technology you know is better than the devil you just heard pitched at the Engineering Leadership meeting.
Databases, Postgres, Performance
225 points by levkk 70 days ago | 188 comments
Did u ever read so hard u accidentally wrote? (danslimmon.com)
Owning a production Postgres database is never boring.
Programming, Databases, Postgres
11 points by todsacerdoti 70 days ago | 2 comments
I replaced my entire tech stack with Postgres [video] (youtube.com)
Postgres, Databases, Technology, Video
13 points by garyclarke27 80 days ago | 0 comments
Show HN: PG-Capture – a better way to sync Postgres with Algolia (or Elastic) (onrender.com)
Schema-based Change-Data-Capture for Postgres
Databases, Postgres, Search, Open Source, SaaS
56 points by nick-keller 83 days ago | 19 comments
Postgres as a Graph Database: (Ab)Using PgRouting (supabase.com)
pgRouting is a Postgres extension. It's often used for finding the “shortest path” between two locations, however it's a hidden gem in Postgres and can be used for basic graph functionality.
Postgres, Graph Databases, Databases, pgRouting, Routing
164 points by michelpp 85 days ago | 44 comments
The Great Re-shard: adding Postgres capacity (again) with zero downtime (2023) (notion.com)
Earlier this year, we swapped out Notion’s live database cluster for a larger one without taking downtime.
Databases, Postgres, Downtime, Scaling, Technology
30 points by unchar1 88 days ago | 8 comments
A Language Server for Postgres (github.com/supabase-community)
A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.
Postgres, Databases, Language Servers, Developer Tools
99 points by tbatchelli 93 days ago | 22 comments
A major Postgres upgrade with zero downtime (instantdb.com)
Right before Christmas we discovered that our Aurora Postgres instance needed a major version upgrade. We found a great essay by the Lyft team, showing how they ran their upgrade with about 7 minutes of downtime.
Databases, Postgres, Upgrades
249 points by stopachka 114 days ago | 76 comments
"Just Use Postgres" Book (manning.com)
You probably don’t need a collection of specialty databases. Just use Postgres instead!
Databases, Postgres, Books
5 points by thunderbong 127 days ago | 1 comments
Reads Causing Writes in Postgres (jesipow.com)
It is good practice to regularly inspect the statements running in the hot path of your Postgres instance. One way to do this is to examine the pg_stat_statements view, which shows various statistics about the SQL statements executed by the Postgres server.
Database, Postgres, Performance Optimization, Monitoring, SQL
224 points by thunderbong 152 days ago | 28 comments
Shrinking a Postgres Table (johnnunemaker.com)
Ok folks, this is kind of a weird one. I'm going to put it in the "you won't ever need this, but if you do, you are going to be glad I wrote this up for ya" category.
Databases, Postgres, Optimization
5 points by plaur782 162 days ago | 0 comments
Django and Postgres for the Busy Rails Developer (andyatkinson.com)
About 10 years ago I wrote a post PostgreSQL for the Busy MySQL Developer, as part of switching from MySQL to Postgres for my personal and professional projects, wherever I could.
Django, Postgres, Rails, Web Development, Databases
180 points by plaur782 163 days ago | 120 comments
Running Durable Workflows in Postgres Using DBOS (supabase.com)
Michael Stonebraker is the inventor of Postgres and a Turing Award winner. His latest venture is DBOS, a three-year joint research project between Stanford and MIT. The DBOS team have built a Durable Workflow engine using Postgres. It's one of the of the more elegant designs I've seen, leveraging the features of Postgres to keep it lightweight and fast.
Databases, Workflow Engines, Postgres, Research
185 points by kiwicopple 164 days ago | 67 comments
Show HN: Performing a zero downtime major version upgrade on RDS Aurora Postgres (medplum.com)
Medplum is built on Postgres. Until recently, our hosted Medplum service was using an Amazon Web Services (AWS) RDS Aurora Postgres cluster running version 12.16. Since v12 is rather outdated and nearing the end of its standard support window on RDS, it was time to plan our upgrade to the newest version available on RDS, v16.4.
AWS, Databases, Postgres, Software
15 points by mattlong 165 days ago | 3 comments
Keyset cursors, not offsets, for Postgres pagination (sequinstream.com)
We're building Sequin, a Postgres CDC tool to streams and queues like Kafka, SQS, HTTP endpoints, and more. Efficient, correct pagination is paramount for our backfill process, so we use keyset cursors extensively.
Databases, Pagination, Postgres, Software Development, Streaming
66 points by todsacerdoti 170 days ago | 7 comments
Pg_parquet – Postgres to Parquet Interoperability (i-programmer.info)
Databases, Data Formats, Postgres, Parquet
4 points by plaur782 176 days ago | 0 comments
Shrinking a Postgres Table (johnnunemaker.com)
Ok folks, this is kind of a weird one. I'm going to put it in the "you won't ever need this, but if you do, you are going to be glad I wrote this up for ya" category.
Databases, Postgres, Optimization
11 points by todsacerdoti 176 days ago | 2 comments
Show HN: Neon-PostgREST – Build a Supabase-Like API/SDK DevX over Neon (github.com/zuplo-samples)
Are you using/considering Neon (or your own hosted Postgres) - but wish you had the ability to interact with your database via API/SDK like Supabase? Look no further! This project shows you exactly how to recreate the Supabase API and developer experience. Try the Demo.
Databases, API, Open Source, Software Development, Postgres
8 points by DataOverload 179 days ago | 2 comments
What I wish someone told me about Postgres (challahscript.com)
I’ve been working professionally for the better part of a decade on web apps and, in that time, I’ve had to learn how to use a lot of different systems and tools.
Databases, Postgres, Web Development
487 points by todsacerdoti 193 days ago | 191 comments