Re: Postgres performance issue - Mailing list pgsql-admin

From Bo Victor Thomsen
Subject Re: Postgres performance issue
Date
Msg-id 63460d2e-7d86-95f4-483d-7168311dd901@gmail.com
Whole thread Raw
In response to Postgres performance issue  (Nikhil Ingale <niks.bgm@gmail.com>)
Responses Re: Postgres performance issue  (Ninad Shah <ninad.shah@percona.com>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Kenny Bachman
Date:
Subject: postrgesql query planner wrong desicion
Next
From: Álvaro Herrera
Date:
Subject: Re: Xmax precedes relation freeze threshold errors