Hacker News new | ask | show | jobs
by richwater 2 days ago
Reading Postgres queuing posts always seem like deja vu. People love to write about them
3 comments

And every time it is "FOR UPDATE SKIP LOCKED" or something else super obvious that should have been a starting point when you pick PG for your queue.
everyone sure acts like postgres is some sort of thing that we discovered next to the antikythera mechanism on the sunken isle of atlantis. the "just get one big machine to do all of the stuff" scaling strategy remains undefeated, though. even if it is presented like it is anything but.
These days, most of them are from the DBOS folks. :)
indeed, every ~week with essentially the same thing: skip locked.