From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Ranier Vilela <ranier(dot)vf(at)gmail(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: calling procedures is slow and consumes extra much memory against calling function |
Date: | 2020-05-16 04:10:03 |
Message-ID: | CAFj8pRAjW9oaZE8VU3BkEyMDpEFH6y3QEf3HT=b1Q=jaMBENyg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
so 16. 5. 2020 v 5:55 odesílatel Ranier Vilela <ranier(dot)vf(at)gmail(dot)com> napsal:
> Em sáb., 16 de mai. de 2020 às 00:07, Pavel Stehule <
> pavel(dot)stehule(at)gmail(dot)com> escreveu:
>
>>
>>
>> so 16. 5. 2020 v 0:34 odesílatel Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
>> napsal:
>>
>>> Em dom., 10 de mai. de 2020 às 17:21, Pavel Stehule <
>>> pavel(dot)stehule(at)gmail(dot)com> escreveu:
>>>
>>>> Hi
>>>>
>>>> I try to use procedures in Orafce package, and I did some easy
>>>> performance tests. I found some hard problems:
>>>>
>>>> 1. test case
>>>>
>>>> create or replace procedure p1(inout r int, inout v int) as $$
>>>> begin v := random() * r; end
>>>> $$ language plpgsql;
>>>>
>>>> This command requires
>>>>
>>>> do $$
>>>> declare r int default 100; x int;
>>>> begin
>>>> for i in 1..300000 loop
>>>> call p1(r, x);
>>>> end loop;
>>>> end;
>>>> $$;
>>>>
>>>> about 2.2GB RAM and 10 sec.
>>>>
>>> I am having a consistent result of 3 secs, with a modified version
>>> (exec_stmt_call) of your patch.
>>> But my notebook is (Core 5, 8GB and SSD), could it be a difference in
>>> the testing hardware?
>>>
>>
>> My notebook is old T520, and more I have a configured Postgres with
>> --enable-cassert option.
>>
> The hardware is definitely making a difference, but if you have time and
> don't mind testing it,
> I can send you a patch, not that the modifications are a big deal, but
> maybe they'll help.
>
send me a patch, please
Pavel
>
> regards,
> Ranier Vilela
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dilip Kumar | 2020-05-16 04:25:42 | Re: Index Skip Scan |
Previous Message | Ranier Vilela | 2020-05-16 03:54:47 | Re: calling procedures is slow and consumes extra much memory against calling function |