BEGIN:VCALENDAR PRODID;X-RICAL-TZSOURCE=TZINFO:-//Calagator//EN CALSCALE:GREGORIAN X-WR-CALNAME:Calagator METHOD:PUBLISH VERSION:2.0 BEGIN:VTIMEZONE TZID;X-RICAL-TZSOURCE=TZINFO:America/Los_Angeles BEGIN:DAYLIGHT DTSTART:20090308T020000 RDATE:20090308T020000 TZOFFSETFROM:-0800 TZOFFSETTO:-0700 TZNAME:PDT END:DAYLIGHT END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090512T200044Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090514T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090514T190000 DTSTAMP;VALUE=DATE-TIME:20090512T200044Z LAST-MODIFIED;VALUE=DATE-TIME:20090513T162930Z UID:http://calagator.org/events/1250457199 DESCRIPTION:This session will survey a few PostgreSQL tuning \;\nparam eters and their effects on the OLTP workload DBT-2. \;\n \;\n-- 3\;\n \;\nPostgreSQL Portland Performance Practice Project (P5) \; \n \;\nSponsored by the Computer Science Department\, Portland State University \;\n \;\nThis series will consist of 5 to 6 presentatio ns aimed at PostgreSQL database users who wish to learn more about tunin g their systems for performance. Attendees will learn how to generate an d interpret operating system (Linux) and database statistics\, and the e ffects 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 on line enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate ho w each tuning technique affects their performance. We will use an open s ource package that the speaker has developed\, called DBT-2\, which many DBAs have found useful. \;\n \;\nMark Wong has an MS in Computer Science from OGI and several years of experience developing and executin g various database systems benchmarks. Most relevant to this series are his years spent at the OSDL developing and using a fair-use derivative o f the TPC-C benchmark to characterize system performance of open source software. \;\n \;\n2nd THURSDAY OF EACH MONTH\, BEGINNING JANUARY 8\, 7:00 PM \;\nPORTLAND STATE UNIVERSITY\, 1900 SW 4th AVENUE\, \ ;\nFOURTH AVENUE BUILDING – ROOM 86-01 \;\n\n\nTags: database test 2\ , dbt-2\, dbt2\, p5\, postgres\, postgresql\n\nImported from: http://cal agator.org/events/1250457199 URL:http://web.cecs.pdx.edu/~len/P5.pdf SUMMARY:PostgreSQL Portland Performance Practice Project (P5) LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT END:VCALENDAR