4 ms·
Postgres supports LISTEN / NOTIFY [1,2], and you can stream a SELECT using COPY or a cursor. 1. http://www.postgresql.org/docs/9.4/static/sql-listen.html http:
by rpedela 12y ago
Postgres supports LISTEN / NOTIFY [1,2], and you can stream a SELECT using COPY or a cursor.
1. http://www.postgresql.org/docs/9.4/static/sql-listen.html http://www.postgresql.org/docs/9.4/static/sql-listen.html
2. http://www.postgresql.org/docs/9.4/static/sql-notify.html http://www.postgresql.org/docs/9.4/static/sql-notify.html
- yummyfajitas 12y agoAlso a brief tutorial on how it works. See in particular the comment by Max Martinsson on how to do it in a replicated scenario. https://www.chrisstucchio.com/blog/2013/postgres_external_triggers.html https://www.chrisstucchio.com/blog/2013/postgres_external_tr...
- est 12y agoLISTEN / NOTIFY is not recommended for production use. It will consume all of your connection pools gradually.
- rpedela 12y agoI can see how that could happen depending on how it is used, but I don't see how that must happen. Can you elaborate?