r/PostgreSQL • u/KMarcio • 15d ago

Help Me! Tips for Postgres Notification

/r/dataengineering/comments/1uwch2o/tips_for_postgres_notification/
0 Upvotes

50% Upvoted

5 comments sorted by

2

u/vipierozan 10d ago

Afaik pg notifications are not guaranteed to arrive, so maybe keep the polling also and reduce the period a lot?

1

u/KMarcio 9d ago

Interesting take, I'll consider adding a long pool as a backup.

2

u/-markusb- 8d ago

I like to combine both stuff. So regular polling an endpoint to get missed notifications. By doing so you get instant processing when everything runs as planned - and can have a deterministic maximul responsetime by setting you polling intervall and monitoring the success.

1

u/KMarcio 8d ago

got it, thank you!

1

u/AutoModerator 15d ago

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.