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:20090223T165823Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090312T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090312T190000 DTSTAMP;VALUE=DATE-TIME:20090223T165823Z LAST-MODIFIED;VALUE=DATE-TIME:20090223T165823Z UID:http://calagator.org/events/1250456742 DESCRIPTION:Sponsored by the Computer Science Department\, Portland State University \;\n \;\nThis series will consist of 5 to 6 presentati ons aimed at PostgreSQL database users who wish to learn more about tuni ng their systems for performance. Attendees will learn how to generate a nd interpret operating system (Linux) and database statistics\, and the effects of some system tuning techniques. This involves studying the wel l known Online Transaction Processing (OLTP) benchmark called TPC-C ( ww w.tpc.org ). TPC-C was developed by a committee\, representing all major players in the database marketplace\, to be representative of typical o nline enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate h ow each tuning technique affects their performance. We will use an open source package that the speaker has developed\, called DBT-2\, which man y DBAs have found useful. \;\n \;\nPORTLAND STATE UNIVERSITY\, 19 00 SW 4th AVENUE\, \;\nFOURTH AVENUE BUILDING – ROOM 86-01\n\nTags: p ortland state university\, psu\, postgres\, postgresql\, dbt-2\, dbt2\n\ nImported from: http://calagator.org/events/1250456742 URL:http://pugs.postgresql.org/node/504 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