From: | Mark Wong <markwkm(at)gmail(dot)com> |
---|---|
To: | Postgresql PDX_Users <pdxpug(at)postgresql(dot)org> |
Subject: | [REMINDER}: February Meeting 2/19/2009 - Using iostat and blktrace to analyze i/o performance |
Date: | 2009-02-18 15:39:46 |
Message-ID: | 70c01d1d0902180739k6feebf26rf741021a6e9612e1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
Ed Borasky will be speaking at the next PDXPUG meeting at FreeGeek (at 7:00pm -
1731 SE 10th Avenue, Portland, OR).
-----
Common wisdom is that "PostgreSQL applications are I/O bound."
Fortunately, Linux has two tools that make analysis of I/O performance
metrics possible: "iostat" and "blktrace". "iostat" gives device-level
operational queuing metrics, and in kernels since 2.6.25, queuing
metrics for individual partitions as well. "blktrace" provides a
detailed trace of every major event in the life of every I/O operation
at the block layer.
This talk looks at some recent "iostat" and "blktrace" results from a
single-disk workstation running "pgbench". I'll include a brief
overview of the operational queuing metrics that "iostat" gives, a
brief run-down on how to install and run "blktrace", and some sample
"blktrace" output.
Looking forward to seeing everyone there....and of course, drinks at
the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd.
afterwards.
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Johnson | 2009-02-19 21:45:54 | thank FREE GEEK? |
Previous Message | gabrielle | 2009-02-14 22:10:11 | Re: Is there really a meeting at the same time as Ignite Portland 5? |