Alan Stange <[EMAIL PROTECTED]> writes:
> Luke Lonergan wrote:
> > Alan,
> > On 11/18/05 9:31 AM, "Alan Stange" <[EMAIL PROTECTED]> wrote:
> >> Here's the output from one iteration of iostat -k 60 while the box is
> >> doing a select count(1) on a 238GB table.
> >> avg-cpu: %user %nice %sys %iowait %idle
> >> 0.99 0.00 17.97 32.40 48.64
> >> Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
> >> sdd 345.95 130732.53 0.00 7843952 0
> >> We're reading 130MB/s for a full minute. About 20% of a single cpu was
> >> being used. The remainder being idle.
> > Cool - thanks for the results. Is that % of one CPU, or of 2? Was the
> > system otherwise idle?
> Actually, this was dual cpu
I hate to agree with him but that looks like a dual machine with one CPU
pegged. Yes most of the time is being spent in the kernel, but you're still
basically cpu limited.
That said, 130MB/s is nothing to sneeze at, that's maxing out two high end
drives and quite respectable for a 3-disk stripe set, even reasonable for a
4-disk stripe set. If you're using 5 or more disks in RAID-0 or RAID 1+0 and
only getting 130MB/s then it does seem likely the cpu is actually holding you
Still it doesn't show Postgres being nearly so CPU wasteful as the original
> It's all in the kernel either way; using a different scheduler or file
> system would change that result. Even better would be using direct IO to not
> flush everything else from memory and avoid some memory copies from kernel
> to user space. Note that almost none of the time is user time. Changing
> postgresql won't change the cpu useage.
Well changing to direct i/o would still be changing Postgres so that's
unclear. And there are plenty of more mundane ways that Postgres is
responsible for how efficiently or not the kernel is used. Just using fewer
syscalls to do the same amount of reading would reduce cpu consumption.
> One IMHO obvious improvement would be to have vacuum and analyze only do
> IO. Now they appear to be very effective memory flushing tools. Table scans
> on tables larger than say 4x memory should probably also use direct IO for
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?