Re: Should from_collapse be switched off? (queries 10 times faster)

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Should from_collapse be switched off? (queries 10 times faster)
Date: 2018-03-23 11:39:07
Message-ID: 71c6894e-f924-4aca-dad7-a22d19bb5b75@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2018-03-23 11:41:35 Re: Should from_collapse be switched off? (queries 10 times faster)
Previous Message Peter 2018-03-23 10:03:08 Should from_collapse be switched off? (queries 10 times faster)