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

Поиск
Список
Период
Сортировка
Искать
От
Thomas Kellerer
Тема
Re: Should from_collapse be switched off? (queries 10 times faster)
Дата
Msg-id
71c6894e-f924-4aca-dad7-a22d19bb5b75@gmx.net
Ответ на
Список
Дерево обсуждения
Should from_collapse be switched off? (queries 10 times faster) Peter <pmc@citylink.dinoex.sub.org>
Re: Should from_collapse be switched off? (queries 10 times faster) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Should from_collapse be switched off? (queries 10 times faster) Tom Lane <tgl@sss.pgh.pa.us>
Re: Should from_collapse be switched off? (queries 10 times faster) Peter <pmc@citylink.dinoex.sub.org>
Re: Should from_collapse be switched off? (queries 10 times faster) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Should from_collapse be switched off? (queries 10 times faster) Peter <pmc@citylink.dinoex.sub.org>
Re: Should from_collapse be switched off? (queries 10 times faster) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Should from_collapse be switched off? (queries 10 times faster) Peter <pmc@citylink.dinoex.sub.org>
Re: Should from_collapse be switched off? (queries 10 times faster) Peter <pmc@citylink.dinoex.sub.org>
Re: Should from_collapse be switched off? (queries 10 times faster) Thomas Kellerer <spam_eater@gmx.net>
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 по дате отправления
От: Peter
Дата:
От: Laurenz Albe
Дата:
FAQ