Re: Postgres performance issue
| От | Ninad Shah |
|---|---|
| Тема | Re: Postgres performance issue |
| Дата | |
| Msg-id | CAMtEjOZEodA-A6S6vjM7FjFHcXh+CRDXd+YV=-1MWFu71_Hriw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Postgres performance issue (Bo Victor Thomsen <bo.victor.thomsen@gmail.com>) |
| Ответы |
Re: Postgres performance issue
|
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: