2.0 -//Pentabarf//Schedule #<Conference_release::Row:0x8083aed40>//EN PGCon2009 Schedule Release #<Conference_release::Row:0x8083aed40> PGCon2009 Schedule PUBLISH 196@PGCon2009@pentabarf.org 196 aster Building PetaByte Warehouses with Unmodified PostgreSQL English en 20090521T100000 20090521T110000 01H00M00S Building PetaByte Warehouses with Unmodified PostgreSQL The data warehousing startup Aster Data will explain how they have built a petabyte-scale data warehousing platform on top of regular open source PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/196.en.html DMS 1160 Emmanuel Cecchet PUBLISH 199@PGCon2009@pentabarf.org 199 Closing sessions prizes, auctions, fun, games English en 20090522T173000 20090522T180000 00H30M00S Closing sessions- prizes, auctions, fun, games The Traditional Closing Session PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/199.en.html DMS 1160 Dan Langille PUBLISH 129@PGCon2009@pentabarf.org 129 Converting 100 databases to PostgreSQL Wisconsin State Courts implementation English en 20090522T113000 20090522T123000 01H00M00S Converting 100 databases to PostgreSQL- Wisconsin State Courts implementation The Wisconsin State Courts converted their databases, physically located at 72 county circuit court sites, as well several central sites, to PostgreSQL in a very short time without major problems. All county servers were converted over the course of a few months. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/129.en.html DMS 1160 Kevin Grittner PUBLISH 152@PGCon2009@pentabarf.org 152 Database Hardware Benchmarking How big is the elephant in your room? English en 20090521T133000 20090521T143000 01H00M00S Database Hardware Benchmarking- How big is the elephant in your room? PostgreSQL DBAs and hardware vendors seem like they're speaking different languages some days. Doing your own low-level hardware benchmarking can provide the secret decoder ring needed to translate all the way from database transactions to disk commits. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/152.en.html DMS 1110 Greg Smith PUBLISH 155@PGCon2009@pentabarf.org 155 Database Refactoring An idea on how to redesign an existing database with minimal downtime English en 20090522T133000 20090522T143000 01H00M00S Database Refactoring- An idea on how to redesign an existing database with minimal downtime Most DBA's have areas of the databases that they manage that they would like to change. However, very few are actually given the liberty, resources, and time to make these changes due to the impact it would have on the existing system's code and the impact on the customers. What if there were a way to get around these obstacles and make the structure changes you want and need without requiring an application rewrite? PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/155.en.html DMS 1160 Chris Hoover PUBLISH 120@PGCon2009@pentabarf.org 120 Encrypted PostgreSQL English en 20090521T113000 20090521T123000 01H00M00S Encrypted PostgreSQL Need to store or access your PostgreSQL data with extra confidentiality? This talk will look at the options available for data and transport encryption in PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/120.en.html DMS 1160 Magnus Hagander PUBLISH 178@PGCon2009@pentabarf.org 178 patches How to Get Your PostgreSQL Patch Accepted patch submission accepted English en 20090522T100000 20090522T110000 01H00M00S How to Get Your PostgreSQL Patch Accepted- patch submission accepted This talk will cover the intricacies of getting your patch accepted by the PostgreSQL community and included in the next software release. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/178.en.html DMS 1160 Bruce Momjian Tom Lane PUBLISH 128@PGCon2009@pentabarf.org 128 Introducing Windowing Functions Internals and Externals English en 20090521T160000 20090521T170000 01H00M00S Introducing Windowing Functions- Internals and Externals PostgreSQL 8.4 has much of the functionality of SQL:2008 windowing functions. In this presentation, you'll learn what windowing functions are for, how they work, both from the end-user and the RDBMS implementation perspective, and plans for future enhancements. You will also learn how to create user-defined windowing functions in C. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/128.en.html DMS 1150 David Fetter Hitoshi Harada PUBLISH 118@PGCon2009@pentabarf.org 118 Introduction to Golconde Golconde is a queue-based data distribution system English en 20090522T150000 20090522T160000 01H00M00S Introduction to Golconde- Golconde is a queue-based data distribution system Learn about Golconde, a queue-based data distribution system developed at myYearbook.com. In implementing data distribution via external message queues, Golconde differentiates itself from traditional PostgreSQL replication tools, moving the workload for replication management outside of PostgreSQL itself. We will review the design decisions that resulted in Golconde as well as see it in action. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/118.en.html DMS 1150 Gavin M. Roy PUBLISH 181@PGCon2009@pentabarf.org 181 Introduction to Recursive Queries Recursion: see recursion English en 20090522T150000 20090522T160000 01H00M00S Introduction to Recursive Queries- Recursion: see recursion Introduction to new 8.4 feature "WITH RECURSIVE" with examples of querying recursive database data structures such as trees or graphs. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/181.en.html DMS 1160 Greg Stark PUBLISH 185@PGCon2009@pentabarf.org 185 lightning Lightning talks Short sharp descriptions of short topics English en 20090522T163000 20090522T173000 01H00M00S Lightning talks- Short sharp descriptions of short topics Lightning talks - details to follow PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/185.en.html DMS 1160 Josh Berkus Leo Hsu and Regina Obe PUBLISH 179@PGCon2009@pentabarf.org 179 No More Waiting A Guide To PostgreSQL 8.4 English en 20090521T100000 20090521T110000 01H00M00S No More Waiting- A Guide To PostgreSQL 8.4 Another year, another PostgreSQL release, and once again this release packed full of new features that will help you whether you develop apps inside or outside the database, or you just need to keep them running. This talk will give an overview of the new features available in 8.4, and give you pointers to talks during the rest of the conference you'll want to focus on to get the most out of 8.4. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/179.en.html DMS 1110 Robert Treat PUBLISH 141@PGCon2009@pentabarf.org 141 OpenStreetMap with PostgreSQL The free wiki world map & PostgreSQL English en 20090521T143000 20090521T153000 01H00M00S OpenStreetMap with PostgreSQL- The free wiki world map & PostgreSQL The OpenStreetMap project is trying to build a free (as in beer) editable electronic map of the world. Data is collected by ordinary people running around with GPS units, tracing imagery and by integrating existing datasets. This talk will an introduction to OpenStreetMap and an overview of how the OpenStreetMap data can be used with PostgreSQL/PostGIS. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/141.en.html DMS 1110 Steve Singer PUBLISH 197@PGCon2009@pentabarf.org 197 Opening Session Welcome English en 20090521T093000 20090521T100000 00H30M00S Opening Session- Welcome Welcome to PGCon 2009 PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/197.en.html DMS 1160 Dan Langille PUBLISH 198@PGCon2009@pentabarf.org 198 dinner PGCon 2009 dinner sponsored by EnterpriseDB English en 20090521T190000 20090521T223000 03H30M00S PGCon 2009 dinner- sponsored by EnterpriseDB The PGCon 2009 dinner. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/198.en.html The Velvet Room Dan Langille PUBLISH 188@PGCon2009@pentabarf.org 188 whackamole Performance Whack-a-Mole II The Moles Are Back, and Bigger Than Ever English en 20090519T130000 20090519T160000 03H00M00S Performance Whack-a-Mole II- The Moles Are Back, and Bigger Than Ever "The database is slow!" How often you've heard that plaintive cry from your co-workers, customers or client. In this tutorial, Josh Berkus will explain his simple methodology for resolving database application performance problems. He'll also demonstrate some of the OS and PostgreSQL tools available for troubleshooting performance problems and show how to use them. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/188.en.html DMS 1110 Josh Berkus PUBLISH 158@PGCon2009@pentabarf.org 158 Post Facto, version control for PostgreSQL English en 20090521T133000 20090521T143000 01H00M00S Post Facto, version control for PostgreSQL Post Facto is an open-source version control system for PostgreSQL databases. Unlike traditional VC tools, which operate on filesystems, Post Facto operates directly on databases, easing the management of multiple schema versions. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/158.en.html DMS 1150 Robert Brewer PUBLISH 124@PGCon2009@pentabarf.org 124 PostgreSQL 8.4Beta Vs PostgreSQL 8.3 A view from the Performance world English en 20090521T143000 20090521T153000 01H00M00S PostgreSQL 8.4Beta Vs PostgreSQL 8.3- A view from the Performance world PostgreSQL 8.4beta will be released on February 2009. We do a quick analysis of how PostgreSQL 8.4B compares to the released 8.3.x product using various workloads and other opensource products PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/124.en.html DMS 1160 Jignesh K. Shah PUBLISH 132@PGCon2009@pentabarf.org 132 control PostgreSQL Access Controls (AuthN, AuthZ, Perms) Controlling Access to your database- Roles; Kerberos, LDAP integration; Database, Schema, Table, and Column-level(!) permissions English en 20090519T090000 20090519T120000 03H00M00S PostgreSQL Access Controls (AuthN, AuthZ, Perms)- Controlling Access to your database- Roles; Kerberos, LDAP integration; Database, Schema, Table, and Column-level(!) permissions PostgreSQL offers many options for controlling access, from authentication and log in to the role system and finally the hierarchy of authorization to specific resources. System Administrators and Database Administrators need to understand these complexities to ensure their system is both robust and secure. With 8.4 there have been many changes to existing options (Kerberos mapping support, finally!) as well as whole new capabilities (column-level privileges, TRUNCATE privilege!). We will go through all of the authentication options that PostgreSQL offers, followed by how to integrate with existing single-sign-on and other infrastructure (Kerberos, LDAP), then walk through setting up roles following best practices and privilege separation, and finally go through the privilege system from database-level down to column-level. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/132.en.html DMS 1110 Stephen Frost PUBLISH 195@PGCon2009@pentabarf.org 195 unit PostgreSQL Unit Testing A BOF English en 20090521T180000 20090521T210000 03H00M00S PostgreSQL Unit Testing- A BOF Come gather with your fellow testing fanatics to share the latest tips and tricks for testing your database. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/195.en.html DMS 1150 David E. Wheeler PUBLISH 151@PGCon2009@pentabarf.org 151 PostgreSQL and Temporal Data English en 20090522T133000 20090522T143000 01H00M00S PostgreSQL and Temporal Data PostgreSQL has had support for storage of temporal data, including a "time travel" capability, since even before it was called PostgreSQL, and PostgreSQL offers a fairly good set of operators to work on temporal data, at least when comparing with SQL standards. This talk describes several of the ways that PostgreSQL may be used to record temporal data, along with advantages and disadvantages. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/151.en.html DMS 1110 Chris Browne PUBLISH 167@PGCon2009@pentabarf.org 167 Power psql All about everyone's favorite utility English en 20090521T170000 20090521T180000 01H00M00S Power psql- All about everyone's favorite utility Covering everything there is to know about psql, the best database command-line utility in existence. Learn tips and tricks to make your sessions more productive and make your coworkers envious. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/167.en.html DMS 1150 Selena Deckelmann PUBLISH 122@PGCon2009@pentabarf.org 122 Predicting Postgres Performance Practical Queueing Theory for Postgres DBAs English en 20090522T113000 20090522T123000 01H00M00S Predicting Postgres Performance- Practical Queueing Theory for Postgres DBAs So, you've solved all of your current performance problems, but are you ready for tomorrow? Suppose your website traffic increases three-fold, or your company has a huge end-of-year processing job to run, at what point will your system become unusable? In this case, is it a CPU problem, I/O problem, or both? Should you add additional CPUs or can you just get faster CPUs? How fast does your I/O subsystem need to be in order to handle your workload? How much would query tuning help? This session is designed to help you answer those questions. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/122.en.html DMS 1150 Jonah H. Harris PUBLISH 192@PGCon2009@pentabarf.org 192 pub Pub Night! Last chance for social intercourse before the Touristy stuff tomorrow English en 20090522T180000 20090522T230000 05H00M00S Pub Night!- Last chance for social intercourse before the Touristy stuff tomorrow The last big social event... PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/192.en.html Royal Oak Dan Langille PUBLISH 146@PGCon2009@pentabarf.org 146 Reconciling and comparing databases Using schemas, Slony, DBI-link, pgTAP and other tools to compare different databases English en 20090522T100000 20090522T110000 01H00M00S Reconciling and comparing databases- Using schemas, Slony, DBI-link, pgTAP and other tools to compare different databases The Millburn Corporation is a hedge fund which uses complex data-driven trading models based on the daily prices of various commodities, currencies and other inputs. As part of our application development process, we use independent stage and test instances of our production database to let us have a smoother and less mistake-prone deployment of new models and price streams. In this talk, I will discuss our setup, which makes heavy use of schemas, Slony, DBI-link, pgTAP and custom deployment tools in order to compare and reconcile data across databases. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/146.en.html DMS 1150 Norman Yamada PUBLISH 190@PGCon2009@pentabarf.org 190 registration Registration pickup The social way to register: at the pub English en 20090520T150000 20090520T180000 03H00M00S Registration pickup- The social way to register: at the pub Pick up your registration pack PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/190.en.html Royal Oak Dan Langille PUBLISH 142@PGCon2009@pentabarf.org 142 SQL/MED Doping for PostgreSQL English en 20090522T133000 20090522T143000 01H00M00S SQL/MED- Doping for PostgreSQL SQL/MED is Management of External Data, a part of the SQL standard that deals with how a database management system can integrate data stored outside the database. The implementation of this specification has begun in PostgreSQL 8.4 and will over time introduce powerful new features into PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/142.en.html DMS 1150 Peter Eisentraut PUBLISH 149@PGCon2009@pentabarf.org 149 amazonrainforest Saving the Amazon with PostGIS Spatial Manipulation in the Rain Forest English en 20090521T113000 20090521T123000 01H00M00S Saving the Amazon with PostGIS- Spatial Manipulation in the Rain Forest Spatial databases are different from other databases through its requirement to store spatial data features, capable of describing its location on space and representation. Its highlighted in the projects the utilization of PostgreSQL with PostGIS. During this lecture it will be discussed the use of the aforementioned tools in the management of spatial database, and the application of spatial analysis techniques on data stored in environmental database. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/149.en.html DMS 1110 Luis Bueno PUBLISH 134@PGCon2009@pentabarf.org 134 SkyTools3: Replication (Londiste3) Overview of Londiste and what's new in version 3 English en 20090521T170000 20090521T180000 01H00M00S SkyTools3: Replication (Londiste3)- Overview of Londiste and what's new in version 3 Replication tool in SkyTools package code named Londiste. General overview of Londiste. Whats new in version 3. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/134.en.html DMS 1110 Priit Kustala PUBLISH 138@PGCon2009@pentabarf.org 138 SkyTools: Queues (PgQ) English en 20090520T090000 20090520T120000 03H00M00S SkyTools: Queues (PgQ) An introduction into PgQ and SkyTools - efficient queue implementation on top of PostgreSQL and the tools to manage it. Description of PgQ, the different kinds of consumers, queue applications and their usage scenarios and how to tie it all together with SkyTools. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/138.en.html DMS 1110 Marko Kreen Martin Pihlak PUBLISH 194@PGCon2009@pentabarf.org 194 ssd Solid State Drives A BOF English en 20090521T180000 20090521T210000 03H00M00S Solid State Drives- A BOF Solid State Drives are the biggest change in storage technology since the hard drive was invented in the 1950s. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/194.en.html DMS 1110 Matthew Wilcox PUBLISH 119@PGCon2009@pentabarf.org 119 Some recent advances in full-text search English en 20090521T100000 20090521T110000 01H00M00S Some recent advances in full-text search We will present some recent improvements in full-text search, we developed during 8.4 development stage and after. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/119.en.html DMS 1150 Oleg Bartunov Teodor Sigaev PUBLISH 174@PGCon2009@pentabarf.org 174 Spatial Analysis with PostGIS English en 20090521T160000 20090521T170000 01H00M00S Spatial Analysis with PostGIS In this lecture we shall describe some use cases of PostGIS -- a brief overview of how it is used in various ways such as for location aware applications, property management, and environmental risk assessment. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/174.en.html DMS 1110 Leo Hsu and Regina Obe PUBLISH 143@PGCon2009@pentabarf.org 143 The Lives of Others Open-Source Development Practices Elsewhere English en 20090521T160000 20090521T170000 01H00M00S The Lives of Others- Open-Source Development Practices Elsewhere A survey of current and emerging development practices in open-source projects, and ideas that the PostgreSQL project could pick up. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/143.en.html DMS 1160 Peter Eisentraut PUBLISH 176@PGCon2009@pentabarf.org 176 The design, architecture, and tradeoffs of FluidDB The database with the heart of a wiki. English en 20090522T150000 20090522T160000 01H00M00S The design, architecture, and tradeoffs of FluidDB- The database with the heart of a wiki. FluidDB is a hosted database that Fluidinfo (http://fluidinfo.com) will launch in alpha early this year. In this talk I will describe: the aspects of FluidDB that make it novel, the reasoning behind this approach to working with data, and the architecture of FluidDB. The system is currently deployed on top of Amazon EC2 and S3, and we are using PostgreSQL as a key component in the architecture. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/176.en.html DMS 1110 Terry Jones PUBLISH 191@PGCon2009@pentabarf.org 191 tourist Tourist Time See the sights in and/or around Ottawa English en 20090523T100000 20090523T140000 04H00M00S Tourist Time- See the sights in and/or around Ottawa Play Tourist PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/191.en.html Out and about Dan Langille PUBLISH 165@PGCon2009@pentabarf.org 165 pgtap Unit Test Your Database! Use a flexible database unit testing framework to assure database integrity and functionality English en 20090521T143000 20090521T153000 01H00M00S Unit Test Your Database!- Use a flexible database unit testing framework to assure database integrity and functionality Given that the database, as the canonical repository of data, is the most important part of many applications, why is it that we don't write database unit tests? This talk promotes the practice of implementing tests to directly test the schema, storage, and functionality of databases. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/165.en.html DMS 1150 David E. Wheeler PUBLISH 189@PGCon2009@pentabarf.org 189 upgrade Upgrade Melee A free-for-all on PostgreSQL's biggest remaining problem English en 20090521T170000 20090521T180000 01H00M00S Upgrade Melee- A free-for-all on PostgreSQL's biggest remaining problem By version 8.5, most of the major issues affecting PostgreSQL usability and adoption will be fixed. Except upgrading. Join our round-table of PostgreSQL hackers to discuss the project's plans to make upgrading PostgreSQL less painful. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/189.en.html DMS 1160 Bruce Momjian Josh Berkus Tom Lane Zdeněk Kotala PUBLISH 184@PGCon2009@pentabarf.org 184 vacuum VACUUM Strategy Autovacuum, FSM, Visibility Map English en 20090522T113000 20090522T123000 01H00M00S VACUUM Strategy- Autovacuum, FSM, Visibility Map VACUUM is a an important topic for new and seasoned users of Postgres. This talk will focus on changes in Postgres from version 8.0 on, how to bast take advantage of configuration parameters related to VACUUM, autovacuum, the updated Free Space Map in 8.4, and the brand new Visibility Map. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/184.en.html DMS 1110 Selena Deckelmann PUBLISH 153@PGCon2009@pentabarf.org 153 Visualizing Postgres English en 20090521T113000 20090521T123000 01H00M00S Visualizing Postgres Postgres provides a variety of metrics that are available via SQL queries. Much of this useful data is transient. By tracking these metrics over time, database, relation, and index trends can be easily visualized using simple graphs and charts, which in turn can be used to assess current server performance, assist in tuning, diagnose performance issues, and anticipate potential future issues. An application for such tracking and visualization will be presented. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/153.en.html DMS 1150 Michael Glaesemann PUBLISH 159@PGCon2009@pentabarf.org 159 haz Writing a Procedural Language I CAN HAZ P.L.Z PLZ? English en 20090520T130000 20090520T160000 03H00M00S Writing a Procedural Language- I CAN HAZ P.L.Z PLZ? PostgreSQL allows development in many different programming languages, to suit the tastes of each aspiring hacker. Learn how to write a PostgreSQL procedural language, using one of the latest, and certainly the least, of these languages, PL/LOLCODE. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/159.en.html DMS 1110 Joshua Tolley PUBLISH 154@PGCon2009@pentabarf.org 154 pg_similarity Functions and Operators for Executing Similarity Queries English en 20090521T133000 20090521T143000 01H00M00S pg_similarity- Functions and Operators for Executing Similarity Queries Similarity query is a fundamental operation in many application areas, such as data integration and cleaning, bioinformatics, and pattern recognition. pg_similarity is a tool that makes available user-friendly methods such as functions and operators for similarity queries. More than a dozen of functions are currently available. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2009/schedule/events/154.en.html DMS 1160 Euler Taveira de Oliveira