79346007

Date: 2025-01-10 14:28:13
Score: 0.5
Natty:
Report link

How are you processing messages in the outbox table?

If you are reading from the Write-Ahead Log (WAL), you can delete the messages as soon as you insert them, as the insertion entry in the WAL will still be there. This is a common practice when implementing this pattern.

You can even take it a step further and write directly to the WAL without even writing to a DB table using pg_logical-emit-message().

Reasons:
  • No code block (0.5):
  • Contains question mark (0.5):
  • Starts with a question (0.5): How are you
  • High reputation (-1):
Posted by: Jon Senchyna