Re: Question on trigger

2024-04-16 Thread Adrian Klaver
On 4/16/24 12:39, veem v wrote: On Sat, 13 Apr 2024 at 21:44, Adrian Klaver > wrote: On 4/13/24 00:03, veem v wrote: > Thank you Adrian. > > So it seems the heavy DML tables will see an impact if having triggers > (mainly for each

Re: Question on trigger

2024-04-16 Thread veem v
On Sat, 13 Apr 2024 at 21:44, Adrian Klaver wrote: > On 4/13/24 00:03, veem v wrote: > > Thank you Adrian. > > > > So it seems the heavy DML tables will see an impact if having triggers > > (mainly for each row trigger) created on them. > > > > And also the bulk DML/array based insert (which inse

Re: Question on trigger

2024-04-13 Thread Adrian Klaver
On 4/13/24 00:03, veem v wrote: Thank you Adrian. So it seems the heavy DML tables will see an impact if having triggers (mainly for each row trigger) created on them. And also the bulk DML/array based insert (which inserts multiple rows in one short or one batch) , in those cases it seems t

Re: Question on trigger

2024-04-13 Thread veem v
Thank you Adrian. So it seems the heavy DML tables will see an impact if having triggers (mainly for each row trigger) created on them. And also the bulk DML/array based insert (which inserts multiple rows in one short or one batch) , in those cases it seems the trigger will not make that happen

Re: Question on trigger

2024-04-11 Thread Adrian Klaver
On 4/11/24 07:31, veem v wrote: Hi, We used to use Oracle database in which we had audit triggers(something as below) mandated for all tables by the control team. Now we are going to use the postgresql 15.4 database for one of our applications. So,wanted to understand if there exists any downsi