Re: Fwd: temp_file_limit?

Поиск
Список
Период
Сортировка
От Frits Jalvingh
Тема Re: Fwd: temp_file_limit?
Дата
Msg-id CAKhTGFU_rD30K8M5=AzT6z-VLqR7LdQF1VzgST0zP=ML7gOpKA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: temp_file_limit?  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: Fwd: temp_file_limit?
Список pgsql-performance
@justin

I tried the create statistics variant and that definitely improves the estimate, and with that one of the "bad" cases (the one with the 82 minute plan) now creates a good plan using only a few seconds.
That is a worthwhile path to follow. A bit hard to do, because those conditions can be anything, but I can probably calculate the ones used per customer and create those correlation statistics from that... It is definitely better than tweaking the "poor man's query hints" enable_xxxx 8-/ which is really not helping with plan stability either.

That will be a lot of work, but I'll let you know the results ;)

В списке pgsql-performance по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Fwd: temp_file_limit?
Следующее
От: Frits Jalvingh
Дата:
Сообщение: Re: Fwd: temp_file_limit?