On 02/12/2016 11:22 AM, John R Pierce wrote:
On 2/12/2016 8:09 AM, Sterpu Victor wrote:
The query is very big but I pasted it at the end of the mail with the
EXPLAIN ANALYZE.
I ran that explain through Depesz's 'explain' analyzer.
http://explain.depesz.com/s/c7ts
there's a lot(!) of small steps in that query. I'm going to hazard a
guess that the issue is related to semaphore overhead or something like
that.
certainly, ti would be good to benchmark both OS's on the same version
of postgres, comparing 9.1 to 9.5 isn't fair.
Something else that just dawned on me, the databases are not the same
version, is the data being queried the same in content and size?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
