Skip site navigation (1) Skip section navigation (2)

[REMINDER}: February Meeting 2/19/2009 - Using iostat and blktrace to analyze i/o performance

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 (view raw or flat)
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.

pdxpug by date

Next:From: Daniel JohnsonDate: 2009-02-19 21:45:54
Subject: thank FREE GEEK?
Previous:From: gabrielleDate: 2009-02-14 22:10:11
Subject: Re: Is there really a meeting at the same time as Ignite Portland 5?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group