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  (Balamurugan Thanikachalam <software.balu@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ninad Shah
Дата:
Сообщение: Re: database shutdown hang due to walsender
Следующее
От: Balamurugan Thanikachalam
Дата:
Сообщение: Re: Postgres performance issue