continuous query in postgresql

Question

I have a spatio-temporal database in Postgresql that is continuously updates. I was wondering if there is a technique for continuous query in this database? for example I have temperature data that updates every minute in the database for specific area. I want to perform aggregate queries to show me the temperature every hour (aggregated value).

score 3 · Accepted Answer · answered Aug 23 '12 at 10:11

3

No, you can't continuously update query, but you can receive notification on events of importance and reissue your query.

answered Aug 23 '12 at 10:11

Michael Krelin - hacker

138,757
24
193
173

You mean by LISTEN/NOTIFY techniques? Yes but can I perform other functions (like aggregation) using the information from notifications? – f.ashouri Aug 23 '12 at 10:46
That's the first part of the answer ;-) So you can either get updated data and do the aggregation on client side or reissue the original query. Details depend on your particular tasks. – Michael Krelin - hacker Aug 23 '12 at 10:51

score 0 · Answer 2 · answered Nov 07 '16 at 14:09

0

There are plugins like PipelineDB that may be able to help you

answered Nov 07 '16 at 14:09

Altair7852

1,226
1
14
23

continuous query in postgresql

2 Answers2