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