rom: Milos Babic mailto:milos.ba...@gmail.com> >
Sent: Thursday, April 8, 2021 2:31 PM
To: Szalontai Zoltán mailto:szalontai.zol...@t-online.hu> >
Cc: Pgsql Performance mailto:pgsql-performance@lists.postgresql.org> >
Subject: Re: procedure using CURSOR to insert is extremely slow
Hi Z
; *From:* Milos Babic
> *Sent:* Thursday, April 8, 2021 2:31 PM
> *To:* Szalontai Zoltán
> *Cc:* Pgsql Performance
> *Subject:* Re: procedure using CURSOR to insert is extremely slow
>
>
>
> Hi Zoltan,
>
>
>
> is there any particular reason why you don
solution.
Mike
From: Szalontai Zoltán
Sent: Thursday, April 08, 2021 6:57 AM
To: 'Milos Babic'
Cc: 'Pgsql Performance'
Subject: RE: procedure using CURSOR to insert is extremely slow
Hi Milos,
Inside the loops there are frequently if / else branches value t
using CURSOR to insert is extremely slow
Hi Zoltan,
is there any particular reason why you don't do a bulk insert as:
insert into target_table
select ... from source_table(s) (with joins etc)
Regards,
Milos
On Thu, Apr 8, 2021 at 1:24 PM Szalontai Z
Hi Zoltan,
is there any particular reason why you don't do a bulk insert as:
insert into target_table
select ... from source_table(s) (with joins etc)
Regards,
Milos
On Thu, Apr 8, 2021 at 1:24 PM Szalontai Zoltán <
szalontai.zol...@t-online.hu> wrote:
> Hi,
>
>
>
> We have a Class db.t
How to check execution plans?
We are in the Loop of the Cursor, and we do insert operations in it.
From: Hervé Schweitzer (HER)
Sent: Thursday, April 8, 2021 1:40 PM
To: Szalontai Zoltán ;
pgsql-performance@lists.postgresql.org
Subject: Re: procedure using CURSOR to insert is extremely slow
If you do a delete on the first step without any statistics, you request will
do a full scan of the table, which will be slower.
Did you check the different execution plans ?
From: Szalontai Zoltán
Sent: Thursday, April 8, 2021 01:24 PM
To: pgsql-performance@li
