tag:calagator.org,2005:/events/searchCalagator: Events tagged with: database test 22009-05-13T09:29:30-07:00tag:calagator.org,2005:Calagator::Event/12504569142009-03-31T14:53:55-07:002009-03-31T14:54:46-07:00PostgreSQL Portland Performance Practice Project (P5) - Linux FilesystemsThursday, April 9, 2009 from 7-8pm at Portland State University Fourth Avenue Building (FAB)http://calagator.org/events/12504569142009-04-09T19:00:00-07:002009-04-09T20:00:00-07:00<div class="vevent">
<h1 class="summary">PostgreSQL Portland Performance Practice Project (P5) - Linux Filesystems</h1>
<div class='date'><time class="dtstart dt-start" title="2009-04-09T19:00:00" datetime="2009-04-09T19:00:00">Thursday, April 9, 2009 from 7</time>–<time class="dtend dt-end" title="2009-04-09T20:00:00" datetime="2009-04-09T20:00:00">8pm</time></div>
<div class="location vcard">
<a href='/venues/202390760' class='url'>
<span class='fn org'>Portland State University Fourth Avenue Building (FAB)</span>
</a>
<div class="adr">
<div class="street-address">1900 SW 4th Ave.</div>
<span class="locality">Portland</span>
, <span class="region">OR</span>
<span class="postal-code">97201</span>
<div class='country-name'>US<div>
(<a href='https://maps.google.com/maps?q=1900%20SW%204th%20Ave.,%20Portland%20OR%2097201%20US'>map</a>)
</div>
</div>
<div class="description">
<p>PostgreSQL Portland Performance Practice Project (P5)</p>
<p>Sponsored by the Computer Science Department, Portland State University</p>
<p>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 ( <a href="http://www.tpc.org">www.tpc.org</a> ). 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.</p>
<p>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.</p>
<p>2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM
PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE,
FOURTH AVENUE BUILDING – ROOM 86-01</p>
</div>
<h3>Links</h3>
<ul>
<li><a class="url" href="http://web.cecs.pdx.edu/~len/P5.pdf">Website</a></li>
</ul>
<div class="tags">
<h3>Tags</h3>
<p><a class="p-category" href="/events/tag/database test 2">database test 2</a>, <a class="p-category" href="/events/tag/dbt-2">dbt-2</a>, <a class="p-category" href="/events/tag/dbt2">dbt2</a>, <a class="p-category" href="/events/tag/p5">p5</a>, <a class="p-category" href="/events/tag/postgres">postgres</a>, <a class="p-category" href="/events/tag/postgresql">postgresql</a></p>
</div>
<div class='single_view_right'>
<a href='http://calagator.org/events/1250456914.ics'>Download to iCal</a>
<div id='edit_link'>
<p>You can <a href="http://calagator.org/events/1250456914/edit">edit this event</a>.</p>
</div>
<div id='metadata'>
This item was added directly to Calagator <br /><strong>Tuesday, March 31, 2009 at 2:53pm</strong> and last updated <br /><strong>Tuesday, March 31, 2009 at 2:54pm</strong>.
</div>
</div>
</div>
45.5102 -122.6804tag:calagator.org,2005:Calagator::Event/12504571992009-05-12T13:00:44-07:002009-05-13T09:29:30-07:00PostgreSQL Portland Performance Practice Project (P5)Thursday, May 14, 2009 from 7-8pm at Portland State University Fourth Avenue Building (FAB)http://calagator.org/events/12504571992009-05-14T19:00:00-07:002009-05-14T20:00:00-07:00<div class="vevent">
<h1 class="summary">PostgreSQL Portland Performance Practice Project (P5)</h1>
<div class='date'><time class="dtstart dt-start" title="2009-05-14T19:00:00" datetime="2009-05-14T19:00:00">Thursday, May 14, 2009 from 7</time>–<time class="dtend dt-end" title="2009-05-14T20:00:00" datetime="2009-05-14T20:00:00">8pm</time></div>
<div class="location vcard">
<a href='/venues/202390760' class='url'>
<span class='fn org'>Portland State University Fourth Avenue Building (FAB)</span>
</a>
<div class="adr">
<div class="street-address">1900 SW 4th Ave.</div>
<span class="locality">Portland</span>
, <span class="region">OR</span>
<span class="postal-code">97201</span>
<div class='country-name'>US<div>
(<a href='https://maps.google.com/maps?q=1900%20SW%204th%20Ave.,%20Portland%20OR%2097201%20US'>map</a>)
</div>
</div>
<div class="description">
<p>This session will survey a few PostgreSQL tuning
parameters and their effects on the OLTP workload DBT-2.</p>
<p>--</p>
<p>PostgreSQL Portland Performance Practice Project (P5)</p>
<p>Sponsored by the Computer Science Department, Portland State University</p>
<p>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 ( <a href="http://www.tpc.org">www.tpc.org</a> ). 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.</p>
<p>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.</p>
<p>2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM
PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE,
FOURTH AVENUE BUILDING – ROOM 86-01</p>
</div>
<h3>Links</h3>
<ul>
<li><a class="url" href="http://web.cecs.pdx.edu/~len/P5.pdf">Website</a></li>
</ul>
<div class="tags">
<h3>Tags</h3>
<p><a class="p-category" href="/events/tag/database test 2">database test 2</a>, <a class="p-category" href="/events/tag/dbt-2">dbt-2</a>, <a class="p-category" href="/events/tag/dbt2">dbt2</a>, <a class="p-category" href="/events/tag/p5">p5</a>, <a class="p-category" href="/events/tag/postgres">postgres</a>, <a class="p-category" href="/events/tag/postgresql">postgresql</a></p>
</div>
<div class='single_view_right'>
<a href='http://calagator.org/events/1250457199.ics'>Download to iCal</a>
<div id='edit_link'>
<p>You can <a href="http://calagator.org/events/1250457199/edit">edit this event</a>.</p>
</div>
<div id='metadata'>
This item was added directly to Calagator <br /><strong>Tuesday, May 12, 2009 at 1pm</strong> and last updated <br /><strong>Wednesday, May 13, 2009 at 9:29am</strong>.
</div>
</div>
</div>
45.5102 -122.6804