From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
---|---|
To: | dlight <avinfo79(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Performance problem in PLPgSQL |
Date: | 2013-09-18 15:47:16 |
Message-ID: | 87vc1yxhij.fsf@news-spur.riddles.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>>>>> "dlight" == dlight <avinfo79(at)gmail(dot)com> writes:
dlight> So if I run function 10000 with varible inside the query in
dlight> one session it's replan each time.
dlight> But if whant to teling postgres do not doing this, what shoud
dlight> i do?
dlight> We have more than 10000 runs in one session with varible
dlight> inside sql. And have big performance problem in 9.2 and 9.3.
dlight> Here is my tests.
dlight> http://postgresql.1045698.n5.nabble.com/function-execute-on-v-9-2-slow-down-tp5767170p5771403.html
One interesting question is: why on earth is that query taking ~500ms
just to plan?
(Second question is, what are the plans and costs for the generic and
custom plans being generated, but that's harder to determine)
--
Andrew (irc:RhodiumToad)
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2013-09-18 15:50:23 | Re: record identical operator |
Previous Message | Robert Haas | 2013-09-18 15:43:31 | Re: relscan_details.h |