pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres performance issue
5+ messages / 5 participants
[nested] [flat]
* Postgres performance issue
@ 2022-06-16 09:43 Nikhil Ingale <niks.bgm@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Nikhil Ingale @ 2022-06-16 09:43 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres performance issue
@ 2022-06-17 02:00 Julien Rouhaud <rjuju123@gmail.com>
parent: Nikhil Ingale <niks.bgm@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Julien Rouhaud @ 2022-06-17 02:00 UTC (permalink / raw)
To: Nikhil Ingale <niks.bgm@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hi,
On Thu, Jun 16, 2022 at 03:13:40PM +0530, Nikhil Ingale wrote:
>
> 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?
I don't know much about oracle or AWR, but you might be interested in
pg_stat_statements extension, or pg_wait_sampling (for wait events) and
pg_stat_kcache (for CPU/disk usage). There are tools that can perform regular
snapshot and display some dashboard based on that, like powa.
If that's not enough or what you need, you can look at
https://wiki.postgresql.org/wiki/Slow_Query_Questions to provide needed
information and get help optimizing your inserts.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres performance issue
@ 2022-06-17 09:34 Bo Victor Thomsen <bo.victor.thomsen@gmail.com>
parent: Nikhil Ingale <niks.bgm@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Bo Victor Thomsen @ 2022-06-17 09:34 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres performance issue
@ 2022-06-24 16:50 Ninad Shah <ninad.shah@percona.com>
parent: Bo Victor Thomsen <bo.victor.thomsen@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Ninad Shah @ 2022-06-24 16:50 UTC (permalink / raw)
To: Bo Victor Thomsen <bo.victor.thomsen@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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.victor.thomsen@gmail.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
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres performance issue
@ 2022-06-25 02:31 Balamurugan Thanikachalam <software.balu@gmail.com>
parent: Ninad Shah <ninad.shah@percona.com>
0 siblings, 0 replies; 5+ messages in thread
From: Balamurugan Thanikachalam @ 2022-06-25 02:31 UTC (permalink / raw)
To: Ninad Shah <ninad.shah@percona.com>; +Cc: Bo Victor Thomsen <bo.victor.thomsen@gmail.com>; pgsql-admin@lists.postgresql.org
Bulk inserts within a explicit transaction, improve the performance.
On Fri, 24 Jun 2022, 22:21 Ninad Shah, <ninad.shah@percona.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.victor.thomsen@gmail.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
>>
>>
>>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2022-06-25 02:31 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-06-16 09:43 Postgres performance issue Nikhil Ingale <niks.bgm@gmail.com>
2022-06-17 02:00 ` Julien Rouhaud <rjuju123@gmail.com>
2022-06-17 09:34 ` Bo Victor Thomsen <bo.victor.thomsen@gmail.com>
2022-06-24 16:50 ` Ninad Shah <ninad.shah@percona.com>
2022-06-25 02:31 ` Balamurugan Thanikachalam <software.balu@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox