Re: Postgres is using 100% CPU

From: Yves Dorfsman <yves(at)zioup(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres is using 100% CPU
Date: 2015-05-29 18:30:15
Message-ID: 5568B037.2050201@zioup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance


> machine. As soon as it starts to Inserting rows into the postgres DB it
> will reach 100%cpu. It will comedown to normal after 40 minutes. I tried perform

How many rows are you inserting at once? How (sql insert? copy? \copy? using a
temp or unlogged table?)?

--
http://yves.zioup.com
gpg: 4096R/32B0F416

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Vondra 2015-05-29 19:20:31 Re: Postgres is using 100% CPU
Previous Message Ashik S L 2015-05-29 18:10:52 Postgres is using 100% CPU

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2015-05-29 19:20:31 Re: Postgres is using 100% CPU
Previous Message Ashik S L 2015-05-29 18:10:52 Postgres is using 100% CPU