Search Postgresql Archives

Re: Slow query when the select list is big

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux