Re: Performance problems with 9.2.15

From: Johan Fredriksson <eskil(at)kth(dot)se>
To: Claudio Freire <klaussfreire(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance problems with 9.2.15
Date: 2016-07-22 00:59:27
Message-ID: 1469149167892.29906@kth.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I can add that setting enable_nestloop = 0 cuts the runtime for this query down to about 4 seconds.
Disabling nested loops globaly does however impacts performance of a lot of other queries.

/ Eskil

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Johan Fredriksson 2016-07-22 01:07:28 Re: Performance problems with 9.2.15
Previous Message Jim Nasby 2016-07-21 22:20:32 Re: less than 2 sec for response - possible?