| From: | Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de> |
|---|---|
| To: | "Weatherby,Gerard" <gweatherby(at)uchc(dot)edu>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How to run a task continuously in the background |
| Date: | 2019-07-17 07:26:13 |
| Message-ID: | BAF99260-A043-4AB7-AB36-6CD84862FEC6@mikatiming.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
We used a trigger that called pg_notify (https://www.postgresql.org/docs/9.5/sql-notify.html) and then had another
process that LISTENed for notifications.
What kind of process is this? I'm assuming that this is an application written in C.
The advantage of LISTEN / NOTIFY is only that the process which should process data does not have to do polling, but is notified when there is something to do.
Dirk
--
Dirk Mika
Software Developer
[cid:image001_d0a5cf51-5dd3-4ff5-b428-1016a6d95a0f.png]
mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany
fon +49 2202 2401-1197
dirk(dot)mika(at)mikatiming(dot)de
www.mikatiming.de
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika
[cid:CCh2U_f27a5ce6-8556-4db1-8aa4-fd610d6e9efe.jpg]<https://youtu.be/qfOFXrpSKLQ>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dirk Mika | 2019-07-17 07:38:42 | Re: How to run a task continuously in the background |
| Previous Message | 王旭 | 2019-07-17 07:18:41 | Issue related with patitioned table:How can I quickly determine which child table my record is in,given a specific primary key value? |