| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Lars Aksel Opsahl <Lars(dot)Opsahl(at)nibio(dot)no>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: SubtransControlLock and performance problems |
| Date: | 2020-02-18 23:46:05 |
| Message-ID: | CAFj8pRB6367VMs8YyBC8Sj0AJ186mq-JvXxi2iQewxAJe2yP=Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
út 18. 2. 2020 v 18:27 odesílatel Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolas PARIS | 2020-02-19 04:42:41 | tablespace to benefit from ssd ? |
| Previous Message | Nagaraj Raj | 2020-02-18 19:10:20 | Re: DB running out of memory issues after upgrade |