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

Related posts about postgresql

Related posts about asynchronous