Re: [PERFORM] Slow query with big tables

2016-08-26 Thread Tommi K
> Hello, > > I have the following tables and query. I would like to get some help to find out why it is slow and how its performance could be improved. > > Thanks, > Tommi K. > > > --Table definitions--- > CREATE TABLE "Measurement" > ( > id bigseri

Re: [PERFORM] Slow query with big tables

2016-08-26 Thread Tommi K
Hello, thanks for the response. I did not get the response to my email even though I am subscribed to the pgsql-performance mail list. Let's hope that I get the next one :) Increasing work_mem did not have great impact on the performance. But I will try to update the PostgreSQL version to see if i