Re: SubtransControlLock and performance problems - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: SubtransControlLock and performance problems
Date
Msg-id CAFj8pRB6367VMs8YyBC8Sj0AJ186mq-JvXxi2iQewxAJe2yP=Q@mail.gmail.com
Whole thread Raw
In response to Re: SubtransControlLock and performance problems  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-performance


út 18. 2. 2020 v 18:27 odesílatel Laurenz Albe <laurenz.albe@cybertec.at> napsal:
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?

no, I didn't

Pavel


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

pgsql-performance by date:

Previous
From: Nagaraj Raj
Date:
Subject: Re: DB running out of memory issues after upgrade
Next
From: Nicolas PARIS
Date:
Subject: tablespace to benefit from ssd ?