ash/eskit
1
0
Fork 0
Code Issues 20 Pull requests Projects Releases Packages Wiki Activity Actions 2

PostgresNotifier: LISTEN/NOTIFY for real-time event delivery #6

New issue
Open
opened 2026-02-19 21:28:02 +00:00 by ash · 0 comments
ash commented 2026-02-19 21:28:02 +00:00
Owner
Copy link

What

Implement StoreNotifier for Postgres using LISTEN/NOTIFY.

Design

  • After event append, fire NOTIFY on a channel with the sequence number
  • PostgresNotifier listens and wakes EventSubscription instantly
  • Include SQL trigger for the events table
  • Fallback: periodic polling if LISTEN connection drops

Performance

  • Benchmark notification latency vs pure polling
  • Test under high write load
  • Test connection recovery
## What Implement StoreNotifier for Postgres using LISTEN/NOTIFY. ## Design - After event append, fire NOTIFY on a channel with the sequence number - PostgresNotifier listens and wakes EventSubscription instantly - Include SQL trigger for the events table - Fallback: periodic polling if LISTEN connection drops ## Performance - Benchmark notification latency vs pure polling - Test under high write load - Test connection recovery
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
No results found.
Labels
Clear labels   
bug

   
documentation

   
enhancement

   
investigation

   
performance

   
production-ready

   
testing
No labels
bug
documentation
enhancement
investigation
performance
production-ready
testing
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
ash/eskit#6
No description provided.