| From: | Ashik S L <ashiksl178(at)gmail(dot)com> |
|---|---|
| To: | "Graeme B(dot) Bell" <grb(at)skogoglandskap(dot)no> |
| Cc: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Postgres is using 100% CPU |
| Date: | 2015-06-02 08:20:13 |
| Message-ID: | CAC=-3DdYqaZGW1DDB7+DOd9QNNCadhfV+qw6MTMjzRt3c5sG-A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Thanks everyone for your response. I will try these settings.
On Tue, Jun 2, 2015 at 1:28 PM, Graeme B. Bell <grb(at)skogoglandskap(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ben.play | 2015-06-03 12:21:32 | How to reduce writing on disk ? (90 gb on pgsql_tmp) |
| Previous Message | Graeme B. Bell | 2015-06-02 07:58:54 | Re: Postgres is using 100% CPU |