Re: [GENERAL] a JOIN to a VIEW seems slow

2017-10-01 Thread Frank Millman
From: Frank Millman Sent: Friday, September 22, 2017 7:34 AM To: pgsql-general@postgresql.org Subject: Re: a JOIN to a VIEW seems slow On Fri, Sep 22, 2017 at 7:34 AM, Frank Millman wrote: > > On Thu, Sep 21, 2017 at 3:54 PM, Merlin Moncure wrote: > > Something is not adding up here. Ca

Re: [GENERAL] time series data

2017-10-01 Thread Clifford Snow
I have a stream that updates every minute with a trigger that updates another table with information from the stream. That way I'm constantly updated with no need to run a script to update before I want a report. Clifford On Sun, Oct 1, 2017 at 10:08 AM, Melvin Davidson wrote: > > > On Sun, Oct

Re: [GENERAL] time series data

2017-10-01 Thread Melvin Davidson
On Sun, Oct 1, 2017 at 4:17 AM, Khalil Khamlichi wrote: > Hi everyone, > > I have a data stream of a call center application coming in to postgres > in this format : > > user_name, user_status, event_time > > 'user1', 'ready', '2017-01-01 10:00:00' > 'user1', 'talking', '2017-01-01 10:02:00' > '

[GENERAL] Revolut - postgres ?

2017-10-01 Thread rakeshkumar464
https://blog.revolut.com/no-excuses-we-let-you-down-32f81e64f974 The career section of the company's web page lists PG as one of the tech stack. Would be interesting to know the details. "At around 07:00 BST on Friday morning, our transaction database began to malfunction. Naturally, we followed

[GENERAL] time series data

2017-10-01 Thread Khalil Khamlichi
Hi everyone, I have a data stream of a call center application coming in to postgres in this format : user_name, user_status, event_time 'user1', 'ready', '2017-01-01 10:00:00' 'user1', 'talking', '2017-01-01 10:02:00' 'user1', 'after_call', '2017-01-01 10:07:00' 'user1', 'ready', '2017-01-01 1