New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Investigate Listen/Notify as alternative to polling #54

Closed

bensheldon opened this issue Jul 23, 2020 · 1 comment · Fixed by #82

Labels

Owner

bensheldon commented Jul 23, 2020

Que uses Listen/Notify.

Some pros/cons here: https://news.ycombinator.com/item?id=9576864

How I did it 5 years ago on another project (ActiveRecord's API may have changed): https://github.com/bensheldon/rails_postgres_websockets_chat/blob/master/app/lib/async_events.rb

bensheldon added the enhancement label

bensheldon mentioned this issue

Add Postgres LISTEN/NOTIFY support #82

Merged

bensheldon closed this as completed in #82

Owner Author

bensheldon commented Aug 21, 2020

Captured the effect of changing to LISTEN/NOTIFY. Dropped from the 1-second polling interval down to tenths of a second (logarithmic scale).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment