frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

PostgreSQL production incident caused by transaction ID wraparound

https://www.sqlservercentral.com/articles/i-too-have-a-production-story-a-downtime-caused-by-postgres-transaction-id-wraparound-problem
21•tcp_handshaker•2h ago

Comments

jffry•1h ago
tl;dr: autovacuum was seen to be active during an earlier incident, assumed to be at fault, and was disabled. It was never re-enabled. The long-term implications of disabling autovacuum were not actively considered.
fallpeak•1h ago
TL;DR: Devs didn't know what they were doing and turned off autovacuum and eventually it broke, then the author decided to have an AI slop out an article about the incident which may or may not have actually occurred.
thesh4d0w•1h ago
Don't forget to include some slop about why SQL Server is better.
plasticeagle•1h ago
AI;DR

Which is why it's

TL;DR

Boring shit article about obvious problem.

fmajid•1h ago
It's not as obvious as you think, GitLab was hit by this a few years ago. But yes, low-quality article and the SQL Server plug is in poor taste.
ozten•4m ago
Many SEV-1s are “obvious”. Still feels like a kick in the stomach if your the one that was response LOLz.
rastignack•1h ago
Just monitor it and you’re done. I’ve delivered and maintained hundreds of pg instances and never faced this issue. There is so much literature about it that at some point no one even slightly skilled will face it.
johnbarron•36m ago
>> Just monitor it and you’re done.

This is just anecdote, colliding with documented database behavior, who is not an issue on Oracle, SQL Server, or IBM DB2.

PostgreSQL explicitly documents xid wraparound as a failure mode that can lead to catastrophic data loss and says vacuuming is required to prevent it. Near exhaustion, it will refuse commands.

Small sample of known outages:

- Sentry — Transaction ID Wraparound in Postgres

https://blog.sentry.io/transaction-id-wraparound-in-postgres...

Mailchimp / Mandrill — What We Learned from the Recent Mandrill Outage

https://mailchimp.com/what-we-learned-from-the-recent-mandri...

Joyent / Manta — Challenges deploying PostgreSQL (9.2) for high availability

https://www.davepacheco.net/blog/2024/challenges-deploying-p...

BattleMetrics — March 27, 2022 Postgres Transacton ID Wraparound

https://learn.battlemetrics.com/article/64-march-27-2022-pos...

Duffel — concurrency control & vacuuming in PostgreSQL

https://duffel.com/blog/understanding-outage-concurrency-vac...

Figma — Postmortem: Service disruption on January 21–22, 2020

https://www.figma.com/blog/post-mortem-service-disruption-on...

Even AWS updated their recommendation as recently as Feb 2025, and is an issue in Aurora Postgres as well as Postgres.

"Prevent transaction ID wraparound by using postgres_get_av_diag() for monitoring autovacuum" https://aws.amazon.com/blogs/database/prevent-transaction-id...

throwatdem12311•1h ago
TL;DR Don’t turn off auto vacuum and periodically tweak your write heavy tables so they are vacuumed regularly enough so this never happens.

NIST scientists create 'any wavelength' lasers

https://www.nist.gov/news-events/news/2026/04/any-color-you-nist-scientists-create-any-wavelength...
80•rbanffy•2h ago•37 comments

The electromechanical angle computer inside the B-52 bomber's star tracker

https://www.righto.com/2026/04/B-52-star-tracker-angle-computer.html
236•NelsonMinar•6h ago•69 comments

Thoughts and feelings around Claude Design

https://samhenri.gold/blog/20260418-claude-design/
174•cdrnsf•4h ago•118 comments

Optimizing Ruby Path Methods

https://byroot.github.io/ruby/performance/2026/04/18/faster-paths.html
30•weaksauce•2h ago•14 comments

Modern Common Lisp with FSET

https://fset.common-lisp.dev/Modern-CL/Top_html/index.html
49•larve•3d ago•1 comments

Migrating from DigitalOcean to Hetzner

https://isayeter.com/posts/digitalocean-to-hetzner-migration/
652•yusufusta•9h ago•337 comments

State of Kdenlive

https://kdenlive.org/news/2026/state-2026/
322•f_r_d•11h ago•107 comments

Traders placed over $1B in perfectly timed bets on the Iran war

https://www.theguardian.com/world/2026/apr/18/iran-war-bets-ethics-concerns
197•trocado•4h ago•123 comments

Michael Rabin has died

https://en.wikipedia.org/wiki/Michael_O._Rabin
374•tkhattra•3d ago•78 comments

Show HN: MDV – a Markdown superset for docs, dashboards, and slides with data

https://github.com/drasimwagan/mdv
80•drasim•8h ago•29 comments

Sumida Aquarium Posts 2026 Penguin Relationship Chart, with Drama and Breakups

https://www.sumida-aquarium.com/special/sokanzu/en/2026/
152•Lwrless•3d ago•5 comments

PgQue: Zero-Bloat Postgres Queue

https://github.com/NikolayS/pgque
64•gmcabrita•6h ago•6 comments

College instructor turns to typewriters to curb AI-written work

https://sentinelcolorado.com/uncategorized/a-college-instructor-turns-to-typewriters-to-curb-ai-w...
85•gnabgib•4h ago•80 comments

Floating Point Fun on Cortex-M Processors

https://danielmangum.com/posts/floating-point-cortex-m/
26•hasheddan•1d ago•1 comments

Opus 4.7 to 4.6 Inflation is ~45%

https://tokens.billchambers.me/leaderboard
386•anabranch•7h ago•407 comments

Show HN: SmallDocs - Markdown without the frustrations

40•FailMore•3d ago•22 comments

Show HN: AI Subroutines – Run automation scripts inside your browser tab

https://www.rtrvr.ai/blog/ai-subroutines-zero-token-deterministic-automation
27•arjunchint•1d ago•3 comments

Scientists discover "cleaner ants" that groom giant ants in Arizona desert

https://www.sciencedaily.com/releases/2026/04/260414075641.htm
66•t-3•3d ago•25 comments

UpCodes (YC S17) is hiring SDRs to help make construction more productive

https://up.codes/careers?utm_source=HN
1•Old_Thrashbarg•6h ago

Show HN: Remoroo. trying to fix memory in long-running coding agents

https://www.remoroo.com
22•adhamghazali•4d ago•4 comments

80386 Memory Pipeline

https://nand2mario.github.io/posts/2026/80386_memory_pipeline/
76•wicket•4d ago•11 comments

Understanding the FFT Algorithm (2013)

https://jakevdp.github.io/blog/2013/08/28/understanding-the-fft/
47•peter_d_sherman•3d ago•6 comments

Amiga Graphics Archive

https://amiga.lychesis.net/
226•sph•17h ago•69 comments

Graphs that explain the state of AI in 2026

https://spectrum.ieee.org/state-of-ai-index-2026
65•bryanrasmussen•6h ago•41 comments

Fuzix OS

https://www.fuzix.org/
70•DeathArrow•8h ago•25 comments

4-bit floating point FP4

https://www.johndcook.com/blog/2026/04/17/fp4/
33•chmaynard•6h ago•19 comments

Category Theory Illustrated – Orders

https://abuseofnotation.github.io/category-theory-illustrated/04_order/
219•boris_m•16h ago•58 comments

It's OK to compare floating-points for equality

https://lisyarus.github.io/blog/posts/its-ok-to-compare-floating-points-for-equality.html
171•coinfused•4d ago•114 comments

Show HN: I made a calculator that works over disjoint sets of intervals

https://victorpoughon.github.io/interval-calculator/
286•fouronnes3•22h ago•49 comments

In the AI propaganda war, Iran is winning

https://www.economist.com/culture/2026/04/17/in-the-ai-propaganda-war-iran-is-winning
24•hebelehubele•4h ago•5 comments