Postgres Webhooks with Pgstream(xata.io)
145 points by mebcitto | 20 comments
First screen, captured .
Looks similar
Database Fundamentals(tontinton.com)
645 points by tontinton | 118 comments
Blog post summarizing core database engineering concepts drawn from Database Internals and Designing Data-Intensive Applications, written by the author of the dbeel database.
SQLite Index Visualization(mrsuh.com)
274 points by mrsuh | 23 comments
MVCC – the part of PostgreSQL we hate the most (2023)(cs.cmu.edu)
341 points by virtualwhys | 109 comments
Andy Pavlo blog post from April 2023 criticizing PostgreSQL's multi-version concurrency control (MVCC) implementation and its drawbacks.
Related stories
PostgreSQL and UUID as Primary Key(maciejwalkowiak.com)
387 points by taubek | 296 comments
A blog post by Maciej Walkowiak discussing the use of UUIDs as primary keys in PostgreSQL, including storage and performance considerations, with Java examples.
Postgres SELECT DISTINCT Does Not Scale(dbos.dev)
83 points by KraftyOne | 26 comments
A DBOS blog post by Peter Kraft explaining why Postgres SELECT DISTINCT queries perform poorly at scale.
PostgreSQL for Everything(raphaelbauer.com)
412 points by karlmush | 238 comments
A blog post by Raphael Bauer arguing for using PostgreSQL as the single backend for many workloads instead of specialized tools.
PostgreSQL reconsiders its process-based model(lwn.net)
761 points by todsacerdoti | 338 comments
LWN article by Jonathan Corbet on PostgreSQL developers discussing moving from a process-per-connection model to a threaded architecture.
Postgres LISTEN/NOTIFY does not scale(recall.ai)
547 points by davidgu | 283 comments
A Recall.ai engineering blog deep dive explaining why Postgres LISTEN/NOTIFY caused scaling problems in their production system.
How Postgres DELETE can actually scale(dbos.dev)
22 points by KraftyOne | 6 comments
A DBOS blog post by Peter Kraft and Qian Li explaining how to make large-scale DELETE operations in Postgres perform and scale well.