2016-05-09 11:01 GMT+03:00 Sterpu Victor <victor@xxxxxxxx>:
I went to 2.4 seconds by joining first the tables that produce many rows.
As you're changing your query quite often, it'd be handy, if you could post both:
- new query version
- it's `EXECUTE (analyze, buffers)` output
If you provide either one or another, but not both, it is difficult to comment on your case.
You can use http://explain.depesz.com/ to post a link to your execution plan here.
--
Victor Y. Yegorov