tai Zoltán <
szalontai.zol...@t-online.hu> wrote:
> Hi Milos,
>
>
>
> Inside the loops there are frequently if / else branches value
> transformations used.
>
> We could not solve it without using a cursor.
>
>
>
> Regards,
>
> Zoltán
>
>
>
>
nserted dummy records into the Target tables with the proper log_id,
> and really the first run became very fast again.
>
>
>
> Is there any “normal” way to speed up this procedure?
>
> In the production environment there will be only “first runs”, the same
> log_id will never be used again.
>
>
>
>
>
> thank
>
> Zoltán
>
>
>
>
>
--
Milos Babic
http://www.linkedin.com/in/milosbabic
Hi Maurici,
as a starting point: can you make sure your GPC instance is configured in
the same way AWS is?
Once you do it, repeat the tests, and post the outcome.
Thanks,
Milos
On Tue, Feb 23, 2021 at 11:14 PM Maurici Meneghetti <
maurici.meneghe...@bixtecnologia.com.br> wrote:
> Hi everyone,
generally, you shouldn't be disabling your constraints, especially if you
are having multiple parallel processes accessing your db.
instead, you should create them DEFERRABLE and have them checked at the end
of your transaction.
regarding your question about NOT NULL: it is not possible to have it
