PostgreSQL Portland Performance Practice Project (P5)
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.
PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01