Bulk inserts within a explicit transaction, improve the performance.
On Fri, 24 Jun 2022, 22:21 Ninad Shah, <ninad.shah@xxxxxxxxxxx> wrote:
You may consider using the Pgbadger tool. This tool extracts data from log files and generates a comprehensive report.Besides, a low INSERT rate is often attributed to a number of factors.
- A number of indexes
- A number of foreign keys
- A number of DB triggers
- A number of long-running queries
- Another processes contributing to the load
- Disk utilisation
Hope this helps!Thanks,NinadOn Fri, Jun 17, 2022 at 3:04 PM Bo Victor Thomsen <bo.victor.thomsen@xxxxxxxxx> wrote: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
