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?