Re: Recommendations on improving the insert on conflict do nothing performance

Hi Muhammad Usman Khan I have already set required values of params.Here issue was about triggers.I have resolved this issue Regards Durga Mahesh On Thu, Sep 12, 2024 at 10:05 AM Muhammad Usman Khan wrote: > Hi, > You can use the following approaches for optimization: > >- Instead of inser

Re: Recommendations on improving the insert on conflict do nothing performance

Hi, You can use the following approaches for optimization: - Instead of inserting one row at a time, perform bulk inserts, which will reduce the overhead of each individual transaction - Partitioning can improve write performance by splitting the data into smaller, more manageable chun