Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres is using 100% CPU - Mailing list pgsql-performance

From Ashik S L
Subject Re: Postgres is using 100% CPU
Date
Msg-id CAC=-3DdYqaZGW1DDB7+DOd9QNNCadhfV+qw6MTMjzRt3c5sG-A@mail.gmail.com
Whole thread Raw
In response to Re: Postgres is using 100% CPU  ("Graeme B. Bell" <grb@skogoglandskap.no>)
List pgsql-performance
Tree view
Thanks everyone for your response. I will try these settings.

On Tue, Jun 2, 2015 at 1:28 PM, Graeme B. Bell <grb@skogoglandskap.no> wrote:
> I believe yes / 0 are the default settings for synchronous commit and commit_delay.   ** (Interestingly the manual pages do not specify.) **

Sorry, I've just spotted the settings in the text. The statement (marked **) is incorrect.

Defaults are yes/0. (http://www.postgresql.org/docs/9.4/static/runtime-config-wal.html)

Graeme.



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Re: Postgres is using 100% CPU
Next
From: "ben.play"
Date:
Subject: How to reduce writing on disk ? (90 gb on pgsql_tmp)