Postgres : Post statement (or insert) asynchronous, non-blocking processing.
Posted
by Hassan Syed
on Stack Overflow
See other posts from Stack Overflow
or by Hassan Syed
Published on 2010-03-06T13:29:16Z
Indexed on
2010/03/08
16:51 UTC
Read the original article
Hit count: 259
I'm wondering if it is possible, that after a collection of rows is inserted, to initiate an operation that is executed asynchronously, is non-blocking, and doesn't need to inform the originator of the request - of the result.
I am working with large amounts of events and I can guarantee that the post-insert logic will not fail -- I just want to have a single insert thread in my event-sources, and I want this thread to keep flying without blocking, and without being responsible for any post-delivery book-keeping.
I can tell you that I would potentially have a 100 of these jobs executing concurrently and each job might operate on 5 tables with anywhere between 200-1000 inserts on each of these tables.
A hint in the right direction should be enough.
© Stack Overflow or respective owner