Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

2012-08-17 Thread Andres Freund
Hi Valentine, On Thursday, August 16, 2012 05:05:11 PM Valentine Gogichashvili wrote: > Hello again, > > now I have restarted the slave with shared_buffers set to 32GB, and now the > recovery process is at 100% CPU: > $ strace -c -f -p 27076 > Process 27076 attached - interrupt to quit > Process

Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

2012-08-17 Thread Andres Freund
On Friday, August 17, 2012 12:51:44 PM Valentine Gogichashvili wrote: > Hello Andreas, > > here are the results of perf profiling: > https://gist.github.com/3b8cb0c15661da439632 > Also attached the files to that mail. > > For a problematic case of big shared_buffers: > > # Events: 320K cycles >