Re: [perf-discuss] cpu migration questions and postgresql

2008-01-18 Thread Roland Mainz
Kugutsumen wrote: > On this quad core box with 8 gig of ram and a 4 gig zfs ARC, I keep seeing > tons of cross calls and cpu migration. > > cross calls go up to 4000 during read only operations and up to 3 during > read and write operations. > > The only thing running is postgresql and a si

Re: [perf-discuss] cpu migration questions and postgresql

2008-01-17 Thread Eric Saxe
It's likely that kernel service threads (which show up as "sched") are preempting postgresql...at which point the runnable postgresql goes back on the run queue to wait, at which point another idle CPU steals it so that it can run immediately. With this happening often things can tend to migrat