Hacker News with Generative AI: Postgres

Making Postgres Distributed with FoundationDB (fabianlindfors.se)
Turning the revered Postgres into a distributed database is a tall order but not a new idea.
Databases, Postgres, Distributed Systems
45 points by emptysea 35 days ago | 17 comments
Short alphanumeric pseudo random identifiers in Postgres (andyatkinson.com)
In this post, we’ll cover a way to generate short, alphanumeric, pseudo random identifiers using native Postgres tactics.
Databases, Postgres, Programming
4 points by speckx 36 days ago | 0 comments
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 41 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 42 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 43 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 44 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 47 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 51 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 68 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 77 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 79 days ago | 4 comments
Postgres Language Server: Initial Release (github.com/supabase-community)
Postgres, Language Servers, Open Source, Databases
362 points by steinroe 90 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 102 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 105 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 105 days ago | 2 comments
I replaced my entire tech stack with Postgres [video] (youtube.com)
Postgres, Databases, Technology, Video
13 points by garyclarke27 115 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 118 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 120 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 123 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 128 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 149 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 162 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 187 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 197 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 198 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 199 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 200 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 205 days ago | 7 comments
Pg_parquet – Postgres to Parquet Interoperability (i-programmer.info)
Databases, Data Formats, Postgres, Parquet
4 points by plaur782 211 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 211 days ago | 2 comments