P5 Speaker Series - Thursday April 9, 7:00 pm

[Mark Wong <markwkm(at)gmail(dot)com>]

For those who are interested in the OLTP oriented presentation with  
PostgreSQL, the next presentation will cover how to test your system  
to determine expected disk performance from various Linux filesystems  
and RAID configurations:

PostgreSQL Portland Performance Practice Project (P5)
A series of presentations by
Mark Wong

Sponsored by the Computer Science Department, Portland State University

This series will consist of 5 to 6 presentations aimed at PostgreSQL  
database users who wish to learn more about tuning their systems for  
performance. Attendees will learn how to generate and interpret  
operating system (Linux) and database statistics, and the effects of  
some system tuning techniques.

This involves studying the well known Online Transaction Processing  
(OLTP) benchmark called TPC-C ( www.tpc.org ). TPC-C was developed by  
a committee, representing all major players in the database  
marketplace, to be representative of typical online enterprise  
databases.

TPC-C consists of a precisely defined schema and 19 queries. We will  
review the schema and queries and demonstrate how each tuning  
technique affects their performance. We will use an open source  
package that the speaker has developed, called DBT-2, which many DBAs  
have found useful.

Mark Wong has an MS in Computer Science from OGI and several years of  
experience developing and executing various database systems  
benchmarks. Most relevant to this series are his years spent at the  
OSDL developing and using a fair-use derivative of the TPC-C benchmark  
to characterize system performance of open source software. He now  
works at HP StorageWorks on their NAS products.

For more information, contact Mark Wong at markwkm(at)postgresql(dot)org(dot)

Thursday, April 9 - 7:00 PM
Portland State University, 1900 SW 4th Avenue,
Fourth Avenue Building – Room 86-01