Re: SubtransControlLock and performance problems

On Mon, 2020-02-17 at 19:41 +0100, Pavel Stehule wrote:
> I tested 
> 
> CREATE OR REPLACE FUNCTION public.fx(integer)
>  RETURNS void
>  LANGUAGE plpgsql
> AS $function$
> begin
>   for i in 1..$1 loop
>   begin
>     insert into foo values(i);
> exception when others then
>   raise notice 'yyy';
> end;
> end loop;
> end;
> $function$
> 
> and I don't see any significant difference between numbers less than 64 and higher

Did you have several concurrent sessions accessing the rows that others created?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com