From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | dlight <avinfo79(at)gmail(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Performance problem in PLPgSQL |
Date: | 2013-09-18 15:19:05 |
Message-ID: | CAFj8pRAup734osQ5r4nNYUJ2V9Rc_V-UFRKV56_RbaUXBJfdVA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello
can you try this patch (commit)
https://github.com/postgres/postgres/commit/a5f11e24a4d1afb213c780812a3df14c04d7f845#diff-fc73a24ee7d0692c2a0c639870223d70?
Regards
Pavel
2013/9/18 dlight <avinfo79(at)gmail(dot)com>
> So if I run function 10000 with varible inside the query in one session
> it's
> replan each time.
>
> But if whant to teling postgres do not doing this, what shoud i do?
>
> We have more than 10000 runs in one session with varible inside sql. And
> have big performance problem in 9.2 and 9.3.
>
> Here is my tests.
>
> http://postgresql.1045698.n5.nabble.com/function-execute-on-v-9-2-slow-down-tp5767170p5771403.html
>
> We want change pg version but can't doing that because of performance
> regression in 9.2 and 9.3.:(
>
>
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Performance-problem-in-PLPgSQL-tp5764796p5771405.html
> Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2013-09-18 15:32:54 | Re: Where to load modules from? |
Previous Message | Pavel Stehule | 2013-09-18 15:11:53 | Re: Assertions in PL/PgSQL |