Asynchronous Trigger?

From: Cory Tucker <cory(dot)tucker(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Asynchronous Trigger?
Date: 2018-03-29 22:29:16
Message-ID: CAG_=8kAdbc_DoJWy11xh5J8b+v-ZWSt3Ty-1Ffdn4scgq3wK6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to have the execution of a trigger (or any function) not
block the completion of the statement they are associated with?

A pattern I had hoped to implement was to do a quick update of rows that
signaled they needed attention, and then an async per-row trigger would
come and do the maintenance (in this case, make an expensive materialized
view).

Any suggestions welcome.

thanks!
--Cory

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ted Filmore 2018-03-29 23:01:13 Autovacuum behavior with rapid insert/delete 9.6
Previous Message Thiemo Kellner 2018-03-29 18:04:48 dblink: could not send query: another command is already in progress