Postgres Pro
Downloads
Home   >   mailing lists

Re: How to run a task continuously in the background - Mailing list pgsql-general

From Rob Sargent
Subject Re: How to run a task continuously in the background
Date
Msg-id C6213713-073F-4F4A-9762-4F7D4EBC2484@gmail.com
Whole thread Raw
In response to Re: How to run a task continuously in the background  (Dirk Mika <Dirk.Mika@mikatiming.de>)
List pgsql-general
Tree view


On Jul 17, 2019, at 1:26 AM, Dirk Mika <Dirk.Mika@mikatiming.de> wrote:

 

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

Also, the NOTIFY wouldn’t significantly extend the lifetime or impact of the trigger.

 

-- 
Dirk Mika
Software Developer

<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.mika@mikatiming.de
www.mikatiming.de

AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884 
Geschäftsführer: Harald Mika, Jörg Mika

<CCh2U_f27a5ce6-8556-4db1-8aa4-fd610d6e9efe.jpg>


pgsql-general by date:

Previous
From: Dirk Mika
Date:
Subject: Re: How to run a task continuously in the background
Next
From: Luca Ferrari
Date:
Subject: Re: How to run a task continuously in the background