Re: [PERFORM] Slow query with big tables

2016-08-29 Thread Tommi Kaksonen
I think I will update to newer version, use better hardware and try materialized views for better performance. Best Regards, Tommi Kaksonen 2016-08-27 21:33 GMT+03:00 Jeff Janes : > On Fri, Aug 26, 2016 at 6:17 AM, Tommi K wrote: > >> Hello, >> thanks for the response. I did

[PERFORM] Slow query with big tables

2016-08-24 Thread Tommi Kaksonen
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 bigserial NOT NULL, product_id bigserial NOT NULL, nominal_data_id bi