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@aklaver.com