Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
GordonS
on Oct 28, 2022
|
parent
|
context
|
favorite
| on:
Push-based outbox pattern with Postgres logical re...
Which way do you mean, using WAL or Publish/Notify?
MapleWalnut
on Oct 28, 2022
[–]
WAL is reliable, but Publish/Notify isn't. You'll lose messages with Publish/Notify if you aren't listening for them.
thom
on Oct 28, 2022
|
parent
|
next
[–]
If you just use notify to tell listeners “there is work in the queue to grab” can you still lose messages? I’ve always seen it implemented where workers have to go and claim items (transactionally), not just wait to be pushed them.
SahAssar
on Oct 29, 2022
|
root
|
parent
|
next
[–]
No, that way is safe. Just make sure that your workers also check for items in the queue when they start.
jerrysievert
on Oct 28, 2022
|
parent
|
prev
[–]
this is exactly what I meant - WAL is your friend.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: