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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What could cause sudden increase in "PARSE" stage of prepared statements?
Date: 2011-03-01 22:17:17
Message-ID: 20110301221717.GA27143@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Browse pgsql-general by date

  From Date Subject
Next Message Pierre Racine 2011-03-01 23:01:36 Dynamic binding in plpgsql function
Previous Message Joshua D. Drake 2011-03-01 21:46:21 #PgEast Training Schedule Up