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.
--
john r pierce, recycling bits in santa cruz