Postgres Pro
Downloads
Home   >   mailing lists

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

From Dirk Mika
Subject Re: How to run a task continuously in the background
Date
Msg-id BAF99260-A043-4AB7-AB36-6CD84862FEC6@mikatiming.de
Whole thread Raw
In response to Re: How to run a task continuously in the background  ("Weatherby,Gerard" <gweatherby@uchc.edu>)
Responses Re: How to run a task continuously in the background
List pgsql-general
Tree view

 

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



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


 
Attachment

pgsql-general by date:

Previous
From: "王旭"
Date:
Subject: Issue related with patitioned table:How can I quickly determine which child table my record is in,given a specific primary key value?
Next
From: Dirk Mika
Date:
Subject: Re: How to run a task continuously in the background