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 BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090331T215355Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090409T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090409T190000 DTSTAMP;VALUE=DATE-TIME:20090331T215355Z LAST-MODIFIED;VALUE=DATE-TIME:20090331T215446Z UID:http://calagator.org/events/1250456914 DESCRIPTION:PostgreSQL Portland Performance Practice Project (P5) \;\n \;\nSponsored by the Computer Science Department\, Portland State Un iversity \;\n \;\nThis 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 eff ects of some system tuning techniques. This involves studying the well k nown Online Transaction Processing (OLTP) benchmark called TPC-C ( www.t pc.org ). TPC-C was developed by a committee\, representing all major pl ayers in the database marketplace\, to be representative of typical onli ne enterprise databases. TPC-C consists of a precisely defined schema an d 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open sou rce package that the speaker has developed\, called DBT-2\, which many D BAs have found useful. \;\n \;\nMark Wong has an MS in Computer Sc ience from OGI and several years of experience developing and executing various database systems benchmarks. Most relevant to this series are hi s years spent at the OSDL developing and using a fair-use derivative of the TPC-C benchmark to characterize system performance of open source so ftware. \;\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\nTags: postgresql\, postgres\, p5 \, dbt2\, database test 2\, dbt-2\n\nImported from: http://calagator.org /events/1250456914 URL:http://web.cecs.pdx.edu/~len/P5.pdf SUMMARY:PostgreSQL Portland Performance Practice Project (P5) - Linux Fil esystems LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT 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