Re: Postgres performance issue

Bulk inserts within a explicit transaction, improve the performance.

On Fri, 24 Jun 2022, 22:21 Ninad Shah, <ninad(dot)shah(at)percona(dot)com> 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,
> Ninad
>
>
> On Fri, Jun 17, 2022 at 3:04 PM Bo Victor Thomsen <
> bo(dot)victor(dot)thomsen(at)gmail(dot)com> 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
>>
>>
>>