Re: Pulling data from Postgres DB table for every 5 seconds.

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: github kran <githubkran(at)gmail(dot)com>, ronljohnsonjr(at)gmail(dot)com
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pulling data from Postgres DB table for every 5 seconds.
Date: 2019-01-09 18:01:23
Message-ID: 4616238f-75f9-fe48-0b5f-7b7978bd7daf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 1/9/19 10:21 AM, github kran wrote:
> Thanks for your reply Rob. Reading the below documentation link says
> the EVENT trigger is only supported for DDL commands. Is it not correct ?.
>
> _1) https://www.postgresql.org/docs/9.6/event-trigger-definition.html _
> (An event trigger fires whenever the event with which it is associated
> occurs in the database in which it is defined. Currently, the only
> supported events are ddl_command_start, ddl_command_end,
> table_rewrite and sql_drop. Support for additional events may be added
> in future releases.).
> 2) Doesnt the trigger slow down inserts/update we are doing to the
> table ?. Does it slow down if we are reading the data using the API
> when we have a trigger in place ?.
>
>
Ah, right you are.  Are triggers off the table?  You would want to write
the trigger function in some (trusted?) language with access to the outside

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scot Kreienkamp 2019-01-09 18:02:06 RE: postgres operational
Previous Message Steve Clark 2019-01-09 17:58:44 postgres operational