77 stories tagged postgresql, newest first.
857 points by ltratt | 744 comments
Dan Luu essay arguing that advancing AI coding models let developers build more ambitious software, citing pgrust, a regex engine, ripgrep fork, and board game AI projects.
150 points by ibobev | 121 comments
Blog post arguing that UUIDv7 does not reliably provide monotonic ordering, accurate creation timestamps, or unguessability, examining RFC 9562 and implementations like Python's.
166 points by f311a | 104 comments
A merged ClickBench pull request removing the pgrust entry for using hand-written per-query kernels and result caching that violate the benchmark rules.
3 points by surprisetalk | 0 comments
A technical blog post explaining how PostgreSQL's TABLESAMPLE SYSTEM and BERNOULLI methods select rows by hashing physical addresses, and the resulting sampling biases.
40 points by plaur782 | 5 comments
Blog post by Jeremy Schneider explaining how Postgres recovery_prefetch amplifies replica IOPS and, with synchronous replication, can cause prolonged write outages, with a repro.
198 points by hans_castorp | 36 comments
Blog post by PostgreSQL committer Peter Eisentraut reflecting on why 8 to 10 significant features were reverted from PostgreSQL 19 during its beta period.
148 points by magoghm | 56 comments
The Register article reporting that PostgreSQL 19's release was pushed to November and up to 10 features reverted after AI review tools surfaced more bugs than developers could fix.
197 points by jascha_eng | 49 comments
GitHub repository for pg_vectorsearch, a Timescale PostgreSQL extension providing high-performance vector search indexing.
146 points by saisrirampur | 148 comments
ClickHouse blog recap of a POSETTE 2026 talk arguing PostgreSQL performance at scale is limited by storage, with benchmarks and a local-NVMe production architecture.
45 points by veqq | 12 comments
Interview with CHICKEN Scheme maintainer Peter Bex covering the CHICKEN 6.0.0 release, Scheme standardization, Postgres vs MySQL/SQLite, and Clojure.
54 points by craigkerstiens | 9 comments
ParadeDB blog post describing search performance improvements in its Postgres-based search extension.
10 points by tenesripranav | 0 comments
A Lupyd blog post arguing that QUIC stream multiplexing beats traditional TCP connection pooling for Postgres over WAN, with benchmark numbers.
6 points by nonmaskable | 6 comments
Blog post from Epure on Sentry's 16GB RAM self-hosting requirement, presenting Epure as a lightweight Rust and Postgres exception-ingest alternative using about 53 MiB.
154 points by birdculture | 92 comments
Blog post explaining pitfalls of Postgres's AT TIME ZONE 'UTC' operator and why it may need to be applied twice.
117 points by vira28 | 40 comments
A browser-based tool that parses PostgreSQL migration SQL with libpg_query WASM and flags operations that may be unsafe, such as locking schema changes.
83 points by KraftyOne | 26 comments
A DBOS blog post by Peter Kraft explaining why Postgres SELECT DISTINCT queries perform poorly at scale.
647 points by polyphilz | 130 comments
Blog post by Rohan Bansal on training a 4B Qwen model with agentic reinforcement learning to generate query plans faster than Postgres's optimizer.
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.
867 points by jonbaer | 84 comments
An interactive 3D city simulation visualizing PostgreSQL internals like WAL, buffer pool, checkpointer, backends, and replication, with a guided tour.
351 points by KraftyOne | 68 comments
A DBOS blog post by Peter Kraft arguing that Postgres LISTEN/NOTIFY can scale, contrary to common belief.
474 points by abelanger | 206 comments
A Hatchet blog post offering startups a guide to keeping their Postgres databases from falling over under load.
749 points by SweetSoftPillow | 635 comments
GitHub repository for pgrust, a rewrite of PostgreSQL in Rust that claims to pass 100% of the Postgres regression tests.
334 points by robhati | 65 comments
A free in-browser tool that parses SQL CREATE TABLE statements and renders an entity-relationship diagram, with PNG/SVG export and no data uploaded.
525 points by levkk | 245 comments
PgDog blog post announcing the company's funding and describing its proxy for horizontally scaling Postgres.
454 points by coffeemug | 104 comments
GitHub repository for pg_durable, Microsoft's open-source PostgreSQL extension providing durable execution of workflows inside the database.
329 points by KraftyOne | 137 comments
DBOS blog post by Peter Kraft arguing that Postgres alone is sufficient to build durable workflow execution, describing DBOS's architecture.
439 points by c0l0 | 222 comments
GitHub repository for pgBackRest, a PostgreSQL backup and restore tool, now archived and read-only with a notice that it is no longer maintained.
357 points by crcastle | 109 comments
Phoronix news article reporting an AWS engineer's finding that Linux 7.0 roughly halves PostgreSQL throughput, with a revert unlikely and PostgreSQL possibly needing changes.
452 points by turtles3 | 256 comments
A Tiger Data blog post by Raja Rao DV arguing that teams should use PostgreSQL for most workloads instead of adding specialized databases, especially in the AI era.
508 points by deofoo | 151 comments
GitHub repository for Craftplan, a self-hosted open-source production management and ERP tool for small artisanal D2C businesses like bakeries.
398 points by haki | 63 comments
Blog post by Haki Benita presenting unconventional, creative techniques for speeding up queries in PostgreSQL beyond standard indexing and query rewrites.
386 points by radimm | 148 comments
A boringSQL blog post by Radim Marek explaining how to create instant database clones in PostgreSQL 18 for testing, migrations, and reproducible snapshots.
635 points by pavel_lishin | 373 comments
A blog post on pierce.dev arguing that self-hosting PostgreSQL is a reasonable alternative to managed database services.
336 points by pil0u | 370 comments
Blog post by Andrew Atkinson arguing against using random UUID version 4 values as primary keys in PostgreSQL, covering performance issues and alternatives.
535 points by dsego | 105 comments
Homepage of PGlite, an embeddable Postgres build that runs a full database locally in WASM with reactivity and live sync.
344 points by speckx | 124 comments
Blog post by Anders Murphy benchmarking SQLite at 100k transactions per second over a billion rows, arguing its embedded single-writer design helps it scale.
354 points by plaur782 | 107 comments
GitHub repository for pg_lake, a Snowflake Labs Postgres extension adding Apache Iceberg tables and data lake file access, using DuckDB.
353 points by tacoooooooo | 132 comments
Blog post by Alex Jacobs arguing about the operational problems of running pgvector for vector search in production that typical posts omit.
436 points by sqliteonline | 136 comments
SQLite Online is a browser-based SQL editor for running queries against SQLite, DuckDB, PGLite, and server databases like MariaDB, PostgreSQL, and MS SQL.
378 points by tosh | 126 comments
Supabase blog post announcing that the OrioleDB patent is now freely available for use by the Postgres community.
320 points by AsyncBanana | 35 comments
A ByteofDev blog post humorously exploring how to tune PostgreSQL configuration settings to make the database as slow as possible.
327 points by ForHackernews | 86 comments
GitHub repository for pgactive, an AWS open-source PostgreSQL extension providing active-active (multi-master) replication.
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.
767 points by surgomat | 212 comments
GitHub repository for Workout.cool, an MIT-licensed open-source fitness coaching platform for building workout plans, tracking progress, and browsing an exercise database.
970 points by Dowwie | 374 comments
Microsoft Tech Community blog post announcing a new PostgreSQL extension/IDE for Visual Studio Code.
531 points by lfittl | 140 comments
A pganalyze blog post by Lukas Fittl explaining the new asynchronous I/O subsystem for disk reads in the Postgres 18 beta and its performance implications.
581 points by aphyr | 138 comments
Jepsen analysis by Kyle Kingsbury showing Amazon RDS for PostgreSQL multi-AZ clusters violate Snapshot Isolation, exhibiting Long Fork anomalies across versions 13.15 to 17.4.
377 points by VoVAllen | 80 comments
A VectorChord blog post arguing that PostgreSQL full-text search is fast when configured correctly, debunking claims that it is slow.
380 points by yarapavan | 109 comments
Blog post by Matt Blewitt recommending seven database technologies to study for a week each in 2025, including Postgres, SQLite, DuckDB, ClickHouse, and others.
389 points by todsacerdoti | 161 comments
A blog post cataloging practical lessons and tips about working with PostgreSQL, including normalization, NULL handling, and making psql more useful.
432 points by jascha_eng | 81 comments
Timescale blog post arguing that standalone vector databases are the wrong abstraction and embeddings should be managed like database indexes, promoting pgai Vectorizer.
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.
493 points by jkatz05 | 102 comments
Official PostgreSQL news announcement of the PostgreSQL 17 release on September 26, 2024.
350 points by jeeybee | 110 comments
GitHub repository for PgQueuer, a Python library that uses PostgreSQL and LISTEN/NOTIFY to implement an efficient job queue.
322 points by kiwicopple | 100 comments
Supabase blog post announcing postgres.new, an in-browser Postgres sandbox built on PGlite (WASM) paired with an LLM assistant for queries, CSV import, charts and RAG.
488 points by drewsberry | 79 comments
A long blog post explaining how PostgreSQL physically stores table data on disk, exploring database folders, files, and page layout.
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.
359 points by n2d4 | 75 comments
GitHub repository for pgmock, an open-source in-memory PostgreSQL implementation for unit and end-to-end tests.
793 points by ajdude | 211 comments
Mastodon post by Josh Berkus reporting that PostgreSQL maintainer Simon Riggs died in a small airplane crash, noting his contributions to replication.
512 points by pinser98 | 201 comments
Figma engineering blog post by Sammy Steele describing how the databases team scaled Figma's Postgres infrastructure, including horizontal sharding.
374 points by saikatsg | 119 comments
GitHub repository for DBeaver, a free universal open-source database tool and SQL client supporting many databases.
1038 points by thunderbong | 70 comments
Blog post from Explain Extended implementing a GPT-style large language model inference in about 500 lines of SQL, as a New Year's post.
432 points by daigoba66 | 114 comments
A blog post by Shekhar Gulati with notes on how GitLab designs its PostgreSQL database schema.
548 points by sh_tomer | 189 comments
A GOV.UK Government Digital Service blog post describing how the team migrated a PostgreSQL database with only 11 seconds of downtime.
335 points by brentjanderson | 104 comments
Knock engineering blog post describing how they upgraded Postgres 11.9 to 15.3 with zero downtime using logical replication, support scripts, and Elixir/BEAM tooling.
643 points by juanfatas | 321 comments
Buildkite blog post explaining their move from integer primary keys to time-ordered UUIDv7 identifiers.
440 points by pella | 47 comments
Official PostgreSQL news announcement of the PostgreSQL 16 release on September 14, 2023.
323 points by clessg | 62 comments
GitHub repository for SQLedge, a tool that replicates a Postgres database to SQLite instances running on the edge.
367 points by pella | 105 comments
Oriole blog post about eliminating VACUUM and table bloat in PostgreSQL using the OrioleDB storage engine.
461 points by todsacerdoti | 160 comments
Xata blog post, part 1 of a series, exploring how to build an advanced full-text search engine using PostgreSQL's built-in features.
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.
335 points by stevekrouse | 107 comments
Val Town blog post explaining why and how the company migrated its database from Supabase to a simpler setup on Render, and lessons learned.
379 points by InitEnabler | 100 comments
GitHub repository for Windmill, an open-source developer platform that turns scripts into workflows and UIs, positioned as an alternative to Airplane and Retool.
1261 points by gmac | 153 comments
Interactive demo page that performs a live, annotated HTTPS request for its own source using subtls, a pure-JavaScript TLS 1.3 implementation.
635 points by philbo | 218 comments
Blog post by Phil Booth describing nine PostgreSQL gotchas, mostly scalability-related, that can cause production problems as databases grow.
557 points by ctc24 | 319 comments
Prequel blog post explaining why the company replaced RabbitMQ with a PostgreSQL-based job queue.
557 points by elorant | 127 comments
Blog post by Dylan Paulus explaining how to model and query graph data structures in PostgreSQL instead of using a dedicated graph database.