Re: Upsert performance considerations (~1 mil/hour)

2019-09-04 Thread Fredrik Blomqvist
Thanks for the response Jeff! On Wed, Sep 4, 2019 at 3:58 PM Jeff Janes wrote: > On Wed, Sep 4, 2019 at 1:30 PM Fredrik Blomqvist < > [email protected]> wrote: > >> Hi, >> >> I have tried doing some research for quite a while on the performanc

Upsert performance considerations (~1 mil/hour)

2019-09-04 Thread Fredrik Blomqvist
Hi, I have tried doing some research for quite a while on the performance implications of the built-in upsert (INSERT ... ON CONFLICT UPDATE...) when a lot of upserts are made. The scale is something like 1 million records/hour, that is split up in groups of around 300 records each. The table is