Re: Query sometimes takes down server
От
marcin mank
Тема
Re: Query sometimes takes down server
Дата
Msg-id
b1b9fac60901151818t43cd690cob79198b12b8649f@mail.gmail.com
Ответ на
Query sometimes takes down server (Jason Long)
Список
Дерево обсуждения
Query sometimes takes down server Jason Long <mailing.list@supernovasoftware.com>
Re: Query sometimes takes down server Jeff Davis <pgsql@j-davis.com>
Re: Query sometimes takes down server "marcin mank" <marcin.mank@gmail.com>
> I have a dynamically built query that will periodically(2 times a day and becoming more frequent) make my server totally unresponsive. does this query involve more than geqo_threshold (default 12) tables? If so, this most probably is geqo (genetic query optimizer) kicking in. Try to fiddle with some geqo parameters (raising geqo_effort is the first choice). Greetings Marcin
В списке pgsql-general по дате отправления
