Re: Postgres performance issue

From: Bo Victor Thomsen <bo(dot)victor(dot)thomsen(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres performance issue
Date: 2022-06-17 09:34:23
Message-ID: 63460d2e-7d86-95f4-483d-7168311dd901@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Álvaro Herrera 2022-06-17 09:53:05 Re: Xmax precedes relation freeze threshold errors
Previous Message Kenny Bachman 2022-06-17 08:48:00 postrgesql query planner wrong desicion