Re: [GENERAL] core system is getting unresponsive because over 300 cpu load - Mailing list pgsql-general

From pinker
Subject Re: [GENERAL] core system is getting unresponsive because over 300 cpu load
Date
Msg-id 1507672430403-0.post@n3.nabble.com
Whole thread Raw
In response to Re: [GENERAL] core system is getting unresponsive because over 300cpu load  (Victor Yegorov <vyegorov@gmail.com>)
Responses Re: [GENERAL] core system is getting unresponsive because over 300cpu load  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: [GENERAL] core system is getting unresponsive because over 300cpu load  (Victor Yegorov <vyegorov@gmail.com>)
List pgsql-general
Victor Yegorov wrote
> Can you provide output of `iostat -myx 10` at the “peak” moments, please?

sure, please find it here:
https://pastebin.com/f2Pv6hDL


Victor Yegorov wrote
> Also, it'd be good to look in more detailed bgwriter/checkpointer stats.
> You can find more details in this post: http://blog.postgresql-
> consulting.com/2017/03/deep-dive-into-postgres-stats_27.html
> (You might want to reset 'shared' stats here.)

thank you for the link, it's really nice explanation. Here you'll find the
full bgwriter stats: https://pastebin.com/VA8pyfXj


--
Victor Yegorov





--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


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

pgsql-general by date:

Previous
From: Dmitry Dolgov
Date:
Subject: Re: [GENERAL] Error: "cached plan must not change result type"
Next
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] core system is getting unresponsive because over 300cpu load