Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YyP3E-0007Jy-2Q for pgsql-performance@arkaria.postgresql.org; Fri, 29 May 2015 18:30:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YyP3C-0000j5-SD for pgsql-performance@arkaria.postgresql.org; Fri, 29 May 2015 18:30:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YyP35-0000Y8-Ow for pgsql-performance@postgresql.org; Fri, 29 May 2015 18:30:27 +0000 Received: from smtp-out-no.shaw.ca ([64.59.134.12]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1YyP31-0001sy-8Y for pgsql-performance@postgresql.org; Fri, 29 May 2015 18:30:26 +0000 Received: from home.zioup.com ([70.72.160.156]) by shaw.ca with SMTP id yP2vYtHPLG8JLyP2wYBw3L; Fri, 29 May 2015 12:30:19 -0600 X-Authority-Analysis: v=2.1 cv=NLUfgROg c=1 sm=1 tr=0 a=1AzCEyHvRsrOnBOCSdCQag==:117 a=1AzCEyHvRsrOnBOCSdCQag==:17 a=N8iSzGwtAAAA:8 a=hTJJpgObMeYA:10 a=IkcTkHD0fZMA:10 a=EcwkyOLhAAAA:8 a=h1PgugrvaO0A:10 a=Gg9QSy6P57lvs3CjwsAA:9 a=QEXdDO2ut3YA:10 a=XCV1zTzjpBgA:10 a=Pvoa1h4JhoMA:10 a=UC2BQ2oY4nQA:10 Received: from [192.168.2.80] (epicurus.zioup.net [192.168.2.80]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by home.zioup.com (Postfix) with ESMTPSA id E1D8CA01A1 for ; Fri, 29 May 2015 12:30:16 -0600 (MDT) Message-ID: <5568B037.2050201@zioup.com> Date: Fri, 29 May 2015 12:30:15 -0600 From: Yves Dorfsman User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Postgres is using 100% CPU References: In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-CMAE-Envelope: MS4wfDryCcpNqJGBR3RaqyyhU2pufR5rSdQ/SmG3uX+z6yfvteegQKV5DCHlyyOk5nf1GqTYZyI3SwPi5XDTadWtply7vjXk8rg2iDJbvAyRKQnlbgA983Zfp7NX1FbSzfpnh1nDx3PChQrvUKdhw6PJ7RI5LejBS1AcKjP7NCywLaX+McQaxx68O1UqSg5t7clmVg== X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance