Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux