Export to

• Google Calendar
• iCalendar file
• hCalendar markup
  <div class="vevent h-event"> <h1 class="summary p-name">PDXPUG: Managing Terabytes</h1> <div class='date'><time class="dtstart dt-start" title="2011-02-17T19:00:00" datetime="2011-02-17T19:00:00">Thursday, February 17, 2011 from 7</time>–<time class="dtend dt-end" title="2011-02-17T21:00:00" datetime="2011-02-17T21:00:00">9pm</time></div> <div class="location vcard p-location h-card"> <a class="url" href='http://calagator.org/venues/202389965'><span class='fn org p-name'>Free Geek</span></a> <div class="adr p-adr h-adr"> <div class="street-address p-street-address">1731 SE 10th Avenue</div> <span class="locality p-locality">Portland</span> , <span class="region p-region">OR</span> <span class="postal-code p-postal-code">97214</span> <div class="country-name p-country-name">US</div> (<a href='https://maps.google.com/maps?q=1731%20SE%2010th%20Avenue,%20Portland%20OR%2097214%20US'>map</a>) </div> </div> <div class="description p-description"> <p>Selena Deckelmann will be talking about managing terabyte instances of PostgreSQL.</p> <p>This will be a preview of her MySQL Users Conference talk:</p> <p><a href="http://en.oreilly.com/mysql2011/public/schedule/detail/17195">http://en.oreilly.com/mysql2011/public/schedule/detail/17195</a></p> <p>Size can creep up on you. Some day you may wake up to a multi-terabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage these systems as they grow, and find out what new features in 9.0 have made life easier for administrators and application developers working with big data.</p> <p>This talk will lead you through solutions to problems Postgres faces when it gets big: backups, transaction wraparound, bloat, huge catalogs and upgrades. You need to monitor the right things, find the gems in DBA-friendly database functions and catalog tables, and know the right places to look to spot problems early. We’ll also go over monitoring best practices and open source tools to get the job done.</p> <p>Working with multiple versions of Postgres back to version 8.2 will be included, and as well as tips on making the most out of new features in 9.0. War stories will be taken from real-world work with Emma, an email marketing company with a few large databases.</p> </div> <h3>Links</h3> <ul> <li><a class="url u-url" href="http://www.postgresql.org">Website</a></li> </ul> </div>