What could cause sudden increase in "PARSE" stage of prepared statements?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема What could cause sudden increase in "PARSE" stage of prepared statements?
Дата
Msg-id 20110301221717.GA27143@depesz.com
обсуждение исходный текст
Список pgsql-general
hi
i have system when we log every query that is over 150ms.

usually we get 100-500 "parse ..." elements per minute, but there are
some cases where the number exceeds 15000 per minute (it's pretty busy
system).

the interesting fact is that io is not taxed, there is no sudden network
traffic, not more than usual queries - all looks normal, but the parses
start to take much longer.

it's 8.3.11 on x64 linux.

what I should look into to solve this mystery?

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: #PgEast Training Schedule Up
Следующее
От: Pierre Racine
Дата:
Сообщение: Dynamic binding in plpgsql function