Postgres Pro
Downloads
Home   >   mailing lists

Re: Should from_collapse be switched off? (queries 10 times faster) - Mailing list pgsql-performance

From Thomas Kellerer
Subject Re: Should from_collapse be switched off? (queries 10 times faster)
Date
Msg-id 71c6894e-f924-4aca-dad7-a22d19bb5b75@gmx.net
Whole thread Raw
In response to Should from_collapse be switched off? (queries 10 times faster)  (Peter <pmc@citylink.dinoex.sub.org>)
List pgsql-performance
Tree view 
Peter schrieb am 23.03.2018 um 11:03:
> My queries get up to 10 times faster when I disable from_collapse
> (setting from_collapse_limit=1).
> 
> After this finding, The pramatic solution is easy: it needs to be
> switched off.

You should post some example queries together with the slow and fast plans. 
Ideally generated using "explain(analyze, buffers)" instead of a simple "explain" to see details on the execution 

Thomas

pgsql-performance by date:

Previous
From: Peter
Date:
Subject: Should from_collapse be switched off? (queries 10 times faster)
Next
From: Laurenz Albe
Date:
Subject: Re: Should from_collapse be switched off? (queries 10 times faster)