Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problems with 9.2.15 - Mailing list pgsql-performance

From Johan Fredriksson
Subject Re: Performance problems with 9.2.15
Date
Msg-id 1469149167892.29906@kth.se
Whole thread Raw
In response to Re: Performance problems with 9.2.15  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Performance problems with 9.2.15
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: less than 2 sec for response - possible?
Next
From: Johan Fredriksson
Date:
Subject: Re: Performance problems with 9.2.15