When: 7-9pm Thu January 19, 2012
Who: Tim Bruce
What: Database Trending
Tim started a new job earlier this year and was looking at how to gather some performance metrics to measure database performance over long periods. While these will change since he works in a very fluid environment, being able to see some differences over time will allow for some forecasting as well. Tim will start by showing some of the things he’s identified, and the code he has, to track these elements and then will lead a round-robin discussion of what other people may be doing to
capture their own metrics.
Tim Bruce has been working with computers for over 25 years doing Data Management, Programming, Systems Administration and Database Administration. Currently, Tim is the Database Administrator for Conducive Technology, the company behind FlightStats.
Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!
Building security will close access to the floor at 7:30.
After-meeting beer location TBD. See you there!
When: 7-9pm Thu November 17, 2011
Who: Mark Wong
What: collectd and Postgres
This presentation is primarily focused on how to use collectd (http://collectd.org/) to collect data from the Postgres statistics tables. Examples of how to use collectd with Postgres will be shown. There is some hackery involved to make collectd do a little more and collect more meaningful data from Postgres. These small patches will be exploited. A small portion of the discussion will be about how to visualize the data.
Mark hangs out at Postgres gatherings here and there to pass the time since he doesn’t really do performance work anymore. [ed: so sad!]
Beer afterwards at the Lucky Lab. See you there!
This month’s meeting marks the third installment in our “”Founders Series”". We’re having a special preview of the talk I’m giving at PgCon.
When: 7-9pm Thu Mar 17, 2011
Who: Gabrielle Roth
What: PostgreSQL Logging
Logging is an important part of your database monitoring suite, providing historical information for troubleshooting and forensic purposes: which user logged in when, what queries they ran and how long they took, when the database restarted. PostgreSQL offers different file format, message format, and message content options for logging. These options can be kind of overwhelming for the first-time user. We’ll walk through the various configuration parameters to help you figure out how to get what you need in a format that’s useful to you. Then we’ll discuss some solutions (pgFouine and friends) for extracting information from your logs.
(Green?) beer afterwards at the Lucky Lab. See you there!
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.