Re: [PERFORM] Sudden crazy high CPU usage

2014-04-02 Thread Michael Paquier
On Wed, Apr 2, 2014 at 7:16 AM, Andres Freund wrote: > On 2014-03-31 19:16:58 +0200, Niels Kristian Schjødt wrote: >> Yes, I could install "perf", though I'm not familiar with it. What would i >> do? :-) > > As root: > perf record -a sleep 5 > perf report > my-nice-perf-report.txt > > And then se

Re: [PERFORM] Why shared_buffers max is 8GB?

2014-04-02 Thread Alexey Klyukin
On Wed, Mar 26, 2014 at 1:21 PM, Alexey Vasiliev wrote: > I read from several sources, what maximum shared_buffers is 8GB. > > Does this true? If yes, why exactly this number is maximum number > of shared_buffers for good performance (on Linux 64-bits)? > > Thanks! > > I've seen cases when going h