https://stackoverflow.com/questions/12206600/how-to-speed-up-insertion-performance-in-postgresql
And You might temporary drop the primary key when bulk loading.
Med venlig hilsen / Kind regards
Bo Victor Thomsen
Den 16-06-2022 kl. 11:43 skrev Nikhil Ingale:
> Hi All,
>
> I'm seeing some performance issue that's bulk inserts are around 15
> inserts per second which is very low. Do we have a performance mgmt
> tool in pg like AWR in oracle?
>
> Regards,
> Nikhil Ingale