2.0 -//Pentabarf//Schedule #<Conference_release::Row:0x808a6a760>//EN PGCon2011 Schedule Release #<Conference_release::Row:0x808a6a760> PGCon2011 Schedule PUBLISH 351@PGCon2011@pentabarf.org 351 9.1 Mystery Tour What's in the upcoming version 20110519T100000 20110519T110000 01H00M00S 9.1 Mystery Tour- What's in the upcoming version SQL/MED, Sync Rep, SSI, Streaming Backups, SE-PostgreSQL, Writeable CTEs, Range Types, per-Column Collations, EXTENSIONs, directory archives, checkpoint goggles, VIEW triggers, extensible ENUMs, and more. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/351.en.html DMS 1160 Josh Berkus PUBLISH 360@PGCon2011@pentabarf.org 360 Advanced WAL file management with OmniPITR. English en 20110520T113000 20110520T123000 01H00M00S Advanced WAL file management with OmniPITR. OmniPITR is a set of scripts designed to help manage and maintain WAL files for Postgres database. It was created in an effort to replace the myriad scripts we've encountered, and written, managing our clients Postgres installs over the years. It includes tools for both archiving, restoration, and creating portable backups on both the master and slave instance. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/360.en.html DMS 1140 Robert Treat PUBLISH 278@PGCon2011@pentabarf.org 278 Android & PostgreSQL How to develop an Android App for PostgreSQL English en 20110520T100000 20110520T110000 01H00M00S Android & PostgreSQL- How to develop an Android App for PostgreSQL This is a presentation on how-to develop a simple Android application that uses the PostgreSQL JDBC driver to communicate directly with a database. Use the Android SDK with Eclipse to build and deploy an application. Familiarity with Java programming and XML recommended. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/278.en.html DMS 1140 Mark Wong PUBLISH 343@PGCon2011@pentabarf.org 343 Best practices with Ora2Pg Migrating Oracle databases to PostgresQL English en 20110519T113000 20110519T123000 01H00M00S Best practices with Ora2Pg- Migrating Oracle databases to PostgresQL Ora2Pg is a GPLv3 licensed tool used to help migrate an Oracle database to a PostgreSQL compatible database. Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate some Oracle data into a PostgreSQL database. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/343.en.html DMS 1160 Gurjeet Singh PUBLISH 375@PGCon2011@pentabarf.org 375 Closing sessions prizes, auctions, fun, games English en 20110520T173000 20110520T183000 01H00M00S Closing sessions- prizes, auctions, fun, games The Traditional Closing Session PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/375.en.html DMS 1160 Dan Langille PUBLISH 300@PGCon2011@pentabarf.org 300 Data-driven cache invalidation English en 20110519T100000 20110519T110000 01H00M00S Data-driven cache invalidation In todays world, nobody (should) deploy a web application facing the internet without having a proper caching system in place. There are many different solutions to choose from, from manual use of memcached through framework integrated caching to external caches like Squid or Varnish. Most modern frameworks come with integrated functionality for at least one of these methods, and often more than one. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/300.en.html DMS 1120 Magnus Hagander PUBLISH 361@PGCon2011@pentabarf.org 361 Database Scalability Patterns: Sharding for Unlimited Growth 20110519T100000 20110519T110000 01H00M00S Database Scalability Patterns: Sharding for Unlimited Growth Most people have come to understand simple replication based horizontal scale-out, but while this technique works pretty well for some read loads, there are system where either the amount of data involved is too great for a single system, or the write based load goes beyond the capacity of a single machine. In these cases we must turn to complex systems of federated databases to build database systems that can sustain perpetual growth. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/361.en.html DMS 1140 Robert Treat PUBLISH 291@PGCon2011@pentabarf.org 291 Distributing Extensions on PGXN Optimal PGXN exposure via Smart distribution packaging English en 20110520T150000 20110520T160000 01H00M00S Distributing Extensions on PGXN- Optimal PGXN exposure via Smart distribution packaging So you've solved a common problem in PostgreSQL, a serious pain point that lots of other people could take advantage of. You want to open-source the code, and would like to package it up and distribute it where people can find it, read its docs, and download and install it. The newest destination for distributing PostgreSQL extensions is [PGXN](http://pgxn.org/), the PostgreSQL Extension network. PGXN offers a central index of PostgreSQL extensions and their documentation, making it easy for people to find an install extensions. How do you optimize your extension distribution for maximum PGXN exposure? By careful packaging, thorough documentation, and simple installation. Join me for an overview of how best to achieve that — including how to build extensions compatible with PostgreSQL 9.1's improved extension support. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/291.en.html DMS 1160 David E. Wheeler PUBLISH 332@PGCon2011@pentabarf.org 332 Doing Bioinformatics in PostgreSQL English en 20110520T133000 20110520T143000 01H00M00S Doing Bioinformatics in PostgreSQL We introduce and describe two modules that grew from the need to perform integrated and efficient Bioinformatics tasks in PostgreSQL: PostBio, a set of methods to store and query genomic sequences and features, and PostStat, a collection of statistical functions that allow for integrated statistical tests. A few practical examples will be presented to showcase the modules. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/332.en.html DMS 1140 Luis Carvalho PUBLISH 282@PGCon2011@pentabarf.org 282 Exploring Automated Join Construction An discussion of HTSQL's join algebra and translation to SQL English en 20110520T133000 20110520T143000 01H00M00S Exploring Automated Join Construction- An discussion of HTSQL's join algebra and translation to SQL This is advanced talk will be an in-depth discussion of HTSQL's query language's design, focusing primarily on techniques used for join specification and translation into SQL. It should be of broad interest to core PostgreSQL core developers. It will likely not be that useful for application developers or users of HTSQL since the talk will be focusing on translation mechanics. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/282.en.html DMS 1120 Clark C. Evans PUBLISH 280@PGCon2011@pentabarf.org 280 Extensions Development both of the feature and developments using it English en 20110520T163000 20110520T173000 01H00M00S Extensions Development- both of the feature and developments using it PostgreSQL extensibility is remarkable but incomplete. It lacks dump and restore support. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/280.en.html DMS 1160 Dimitri Fontaine PUBLISH 350@PGCon2011@pentabarf.org 350 Hacking the Query Planner English en 20110519T163000 20110519T173000 01H00M00S Hacking the Query Planner What does the planner do and why does it do it? How can it be improved? PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/350.en.html DMS 1120 Tom Lane PUBLISH 382@PGCon2011@pentabarf.org 382 Hacking the Query Planner II English en 20110520T133000 20110520T143000 01H00M00S Hacking the Query Planner II What does the planner do and why does it do it? How can it be improved? PART II This is a continuation of Tom's talk from yesterday. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/382.en.html DMS 1160 Tom Lane PUBLISH 303@PGCon2011@pentabarf.org 303 How To Get Your PostgreSQL Patch Accepted In short: -1 from me. regards, tom lane English en 20110519T133000 20110519T143000 01H00M00S How To Get Your PostgreSQL Patch Accepted- In short: -1 from me. regards, tom lane Writing a PostgreSQL patch can be difficult, and getting it accepted can require even more work than writing it in the first place. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/303.en.html DMS 1120 Robert Haas PUBLISH 344@PGCon2011@pentabarf.org 344 Label Based Mandatory Access Control on PostgreSQL English en 20110520T100000 20110520T110000 01H00M00S Label Based Mandatory Access Control on PostgreSQL PostgreSQL v9.1 shall be released with a long-awaited feature that enables to apply label based mandatory access control. It was primarily developed to integrate security model of SELinux, however, it was evolved to more generic design by community efforts. Nowadays, we can apply an additional security mechanism from a difference perspective in addition to the default database privileges. This session offers a brief overview of this model, an introduction of what's new in v9.1 and limitations to be overcome in the future release. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/344.en.html DMS 1120 KaiGai Kohei PUBLISH 340@PGCon2011@pentabarf.org 340 Life with Object-Relational Mappers Or, how I stopped worrying and learned to love the ORM English en 20110518T090000 20110518T120000 03H00M00S Life with Object-Relational Mappers- Or, how I stopped worrying and learned to love the ORM Object-Relational Mappers (ORMs) are the primary interface that application programmers now use to interact with SQL databases. Any DBA can list the problems that they create, but how can we move on to solutions that don't involve a complete reengineering the ORM-database interaction paradigm? Rather than simply declaim that ORMs are bad, let's find a way of mitigating the problems that existing ORMs create. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/340.en.html DMS 1120 Christophe Pettus PUBLISH 369@PGCon2011@pentabarf.org 369 lightning Lightning talks Short sharp descriptions of short topics English en 20110519T173000 20110519T183000 01H00M00S Lightning talks- Short sharp descriptions of short topics A regular feature, PGCon will have a Lightning talks session, with presentations on diverse topics. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/369.en.html DMS 1160 Magnus Hagander Selena Deckelmann PUBLISH 297@PGCon2011@pentabarf.org 297 MVCC Unmasked English en 20110519T113000 20110519T133000 02H00M00S MVCC Unmasked Multi-Version Concurrency Control (MVCC) allows Postgres to offer high concurrency even during significant database read/write activity. MVCC specifically offers behavior where "readers never block writers, and writers never block readers". PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/297.en.html DMS 1120 Bruce Momjian PUBLISH 366@PGCon2011@pentabarf.org 366 bigpostgres Maintaining Terabytes 10 Things to Watch Out For When PostgresSQL Gets Big English en 20110519T133000 20110519T143000 01H00M00S Maintaining Terabytes- 10 Things to Watch Out For When PostgresSQL Gets Big 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. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/366.en.html DMS 1160 Selena Deckelmann PUBLISH 380@PGCon2011@pentabarf.org 380 socialouting Major Social Event! sponsored by EnterpriseDB English en 20110519T183000 20110519T203000 02H00M00S Major Social Event!- sponsored by EnterpriseDB Come and join us for the major evening social event of PGCon 2011! PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/380.en.html The Velvet Room Dan Langille PUBLISH 307@PGCon2011@pentabarf.org 307 NTT’s Case Report Introduce PostgreSQL into reliable and large-scale telecommunication support system English en 20110519T150000 20110519T160000 01H00M00S NTT’s Case Report- Introduce PostgreSQL into reliable and large-scale telecommunication support system We will present how to introduce PostgreSQL into NTT’s telecommunication systems. To inform the merit of PostgreSQL for IT system managers we evaluated its performance and showed applicable field of our production systems. To broaden the field we have resolved performance problems like as performance glitch at checkpoints and improved its usability with home-made tools such as pg_bulkload, pg_statsinfo and so on. All these efforts and their results are worth being shared with who plan and proceed PostgreSQL’s enterprise use. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/307.en.html DMS 1120 Tetsuo Sakata PUBLISH 374@PGCon2011@pentabarf.org 374 pldevs PL Developer Summit PL/Mania English en 20110521T093000 20110521T133000 04H00M00S PL Developer Summit- PL/Mania Procedural Language PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/374.en.html DMS 1110 Selena Deckelmann PUBLISH 352@PGCon2011@pentabarf.org 352 Parallel Image Searching Using PostgreSQL and PgOpenCL Running PostgreSQL Stored Procedures on a GPU English en 20110519T150000 20110519T160000 01H00M00S Parallel Image Searching Using PostgreSQL and PgOpenCL- Running PostgreSQL Stored Procedures on a GPU 2D and 3D Image data is increasing important. New 3D scanning devices are being used to map a variety of large and small spaces and objects. Large GIS data sets are being acquired with new scanners. Computation photography allows the manipulation of images for many applications both scientific and social. GPUs are increasingly being used to accelerate image based computations. This presentation illustrates how PostgreSQL can store and process images using GPU hosted stored procedures, written in OpenCL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/352.en.html DMS 1160 Tim Child PUBLISH 373@PGCon2011@pentabarf.org 373 keynote PostGIS Knows Where You Are Should you be Worried? English en 20110519T090000 20110519T100000 01H00M00S PostGIS Knows Where You Are- Should you be Worried? Paul Ramsey has been working with geospatial software for more than 10 years, as programmer and consultant. He co-founded the PostGIS spatial database project in 2001, and is currently an active developer and member of the project steering committee. In 2008, Paul received the Sol Katz Award for achievement in open source geospatial software. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/373.en.html DMS 1160 Paul Ramsey PUBLISH 292@PGCon2011@pentabarf.org 292 PostgreSQL Logging How to get the most out of your activity log English en 20110519T163000 20110519T173000 01H00M00S PostgreSQL Logging- How to get the most out of your activity log Logs can tell you a lot about what's going on in your database: which user logged in when, what queries they ran and how long they took, when the database restarted. We'll walk through the various logging configuration options PostgreSQL offers to help you figure out how to get what you need in a format that's useful to you. We'll also talk about what to do with your logs once you have them (hint: you don't have to stay up at night reading through them!) and, time permitting, wrap up with a group discussion. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/292.en.html DMS 1140 Gabrielle Roth PUBLISH 336@PGCon2011@pentabarf.org 336 PostgreSQL Performance Pitfalls Keeping yourself out of the pit English en 20110517T130000 20110517T160000 03H00M00S PostgreSQL Performance Pitfalls- Keeping yourself out of the pit PostgreSQL is a database system that can deliver excellent performance for a wide variety of applications. But it's easy to run into an issue that keeps you from seeing its full potential. There are a few basic PostgreSQL configuration and use misunderstandings that cause most of the early performance issues administrators and developers encounter. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/336.en.html DMS 1120 Greg Smith PUBLISH 311@PGCon2011@pentabarf.org 311 Range Types Range Types and Temporal Data English en 20110520T100000 20110520T110000 01H00M00S Range Types- Range Types and Temporal Data Range Types are a new feature that captures ranges -- ranges of time, ranges of numbers, ranges of dates -- and gives users the ability to create their own range types. Using Range Types improves performance by using range indexes, simplifies your queries and schema, and enables advanced features such as using Exclusion Constraints to prevent overlap. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/311.en.html DMS 1160 Jeff Davis PUBLISH 353@PGCon2011@pentabarf.org 353 Real Federation Database System leveraging PostgreSQL FDW English en 20110519T133000 20110519T143000 01H00M00S Real Federation Database System leveraging PostgreSQL FDW Federation Database System solves transparent access to heterogeneous DBMS to realize Optimized Database schema design according to optimized business process. Our database team develops Real Federation Database System leveraging PostgreSQL FDW. This federation system enhances the current optimization of Foreign Scan and adds Foreign Data Wrapper for another RDBMS such as Oracle and Microsoft SQL Server. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/353.en.html DMS 1140 Yotaro Nakayama PUBLISH 379@PGCon2011@pentabarf.org 379 registration Registration pickup The social way to register: at the pub English en 20110518T150000 20110518T220000 07H00M00S Registration pickup- The social way to register: at the pub Pick up your registration pack PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/379.en.html Royal Oak Dan Langille PUBLISH 368@PGCon2011@pentabarf.org 368 Review of Patch Reviewing How to Review Patches for PostgreSQL 20110519T113000 20110519T123000 01H00M00S Review of Patch Reviewing- How to Review Patches for PostgreSQL Patch reviewing is an important part of moving PostgreSQL forward. It's critical for anyone submitting patches to PostgreSQL to also understand how to review patches, too. This talk will go through the steps of patch review, including the most important piece- code review. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/368.en.html DMS 1140 Stephen Frost PUBLISH 286@PGCon2011@pentabarf.org 286 Running PostgreSQL in enterprise level telco systems English en 20110520T163000 20110520T173000 01H00M00S Running PostgreSQL in enterprise level telco systems A specific example of using PostgreSQL in enterprise level OSS system for largest pan-russian cellular provider - technology choice reasoning, implementation, maintenance and performance issues. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/286.en.html DMS 1140 Ilya Kosmodemiansky PUBLISH 309@PGCon2011@pentabarf.org 309 SP-GiST - a new indexing infrastructure for PostgreSQL Space-Partitioning trees in PostgreSQL English en 20110520T113000 20110520T123000 01H00M00S SP-GiST - a new indexing infrastructure for PostgreSQL- Space-Partitioning trees in PostgreSQL We want to present a prototype of new indexing infrastructure, called SP-GiST, which greatly extends current extendability of PostgreSQL to support space-partitioning trees, as well as a family of digital trees like suffix tree, patricia. We'll present programming interface, examples of realizations of some useful datatypes. Also, we'd like to discuss some implementation issues and roadmap for inclusion to PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/309.en.html DMS 1160 Oleg Bartunov Teodor Sigaev PUBLISH 296@PGCon2011@pentabarf.org 296 Securing PostgreSQL From External Attack English en 20110519T163000 20110519T173000 01H00M00S Securing PostgreSQL From External Attack This talk explores the ways attackers with no authorized database access can steal Postgres passwords, see database queries and results, and even intercept database sessions and return false data. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/296.en.html DMS 1160 Bruce Momjian PUBLISH 333@PGCon2011@pentabarf.org 333 Serializable Snapshot Isolation in Postgres Making ISOLATION LEVEL SERIALIZABLE Provide Serializable Isolation English en 20110520T163000 20110520T173000 01H00M00S Serializable Snapshot Isolation in Postgres- Making ISOLATION LEVEL SERIALIZABLE Provide Serializable Isolation Serializable isolation makes it easier to reason about database behavior because concurrent transactions appear to have executed sequentially. However, Postgres has historically only provided snapshot isolation, even at the SERIALIZABLE isolation level, which can expose anomalous states to queries. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/333.en.html DMS 1120 Dan Ports Kevin Grittner PUBLISH 337@PGCon2011@pentabarf.org 337 The Write Stuff Reaching peak write performance under heavy loads English en 20110520T150000 20110520T160000 01H00M00S The Write Stuff- Reaching peak write performance under heavy loads One of the most difficult things to do with a database system is handle a high volume of writes, whether it's from a single user or thousands. The steps a database like PostgreSQL takes to protect your data are expensive, and it's hard to split them into independent pieces. Recent changes available in the upcoming PostgreSQL 9.1 have given new insight into exactly how PostgreSQL systems that write constantly break down under serious loads. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/337.en.html DMS 1140 Greg Smith PUBLISH 376@PGCon2011@pentabarf.org 376 tourist Tourist stuff Spend some time exploring English en 20110521T100000 20110521T150000 05H00M00S Tourist stuff- Spend some time exploring Explore Ottawa PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/376.en.html Out and about Dan Langille PUBLISH 357@PGCon2011@pentabarf.org 357 Trees and Graphs in the database RDBMS in the social networks age English en 20110518T130000 20110518T160000 03H00M00S Trees and Graphs in the database- RDBMS in the social networks age Despite the NoSQL movement trying to flag traditional databases as a dying breed, the RDBMS keeps evolving and adding new powerful weapons to its arsenal. In this talk we'll explore Common Table Expressions (SQL-99) and how SQL handles recursion, breaking the bi-dimensional barriers and paving the way to more complex data structures like trees and graphs, and how we can replicate features from social networks and recommendation systems. We'll also have a look at window functions (SQL:2003) and the advanced reporting features they make finally possible. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/357.en.html DMS 1120 Lorenzo Alberton PUBLISH 287@PGCon2011@pentabarf.org 287 Understanding PostgreSQL LWLocks English en 20110519T150000 20110519T160000 01H00M00S Understanding PostgreSQL LWLocks In this session we take a look at the Light Weight Lock facility in PostgreSQL and the various lwlocks. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/287.en.html DMS 1140 Jignesh K. Shah PUBLISH 356@PGCon2011@pentabarf.org 356 Using PostgreSQL for Flight Planning How PostgreSQL is being used at www.worldflightplanner.com English en 20110520T150000 20110520T160000 01H00M00S Using PostgreSQL for Flight Planning- How PostgreSQL is being used at www.worldflightplanner.com Postgres is a powerful database, especially when coupling it with PostGIS to make it spatially aware. Using PostgreSQL and PostGIS allows World Flight Planner to provide advanced flight planning tools to both private and commercial pilots. Using PostgreSQL and PostGIS allows you to access and modify your spatial data using SQL. This talk will provide an overview on the advantages to using PostGIS, how to properly store and query your geographic data, and offer some solutions to common problems. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/356.en.html DMS 1120 Blake Crosby PUBLISH 305@PGCon2011@pentabarf.org 305 Using The PostgreSQL System Catalogs Database Introspection with PostgreSQL English en 20110517T090000 20110517T120000 03H00M00S Using The PostgreSQL System Catalogs- Database Introspection with PostgreSQL The PostgreSQL system catalogs store metadata about SQL objects such as tables, columns, functions, schemas, and more. This talk will explore the organization and structure of the system catalogs and explain how you can use these catalogs to manage and tune your database. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/305.en.html DMS 1120 Robert Haas PUBLISH 378@PGCon2011@pentabarf.org 378 Writeable CTEs A Revolution in SQL English en 20110520T113000 20110520T123000 01H00M00S Writeable CTEs- A Revolution in SQL In SQL, Common Table Expressions are a way of creating and using views at run time, but only in read queries. Here we discover ways to use them in writes. Find out about this exciting new feature! PUBLIC CONFIRMED Lecture http://www.pgcon.org/2011/schedule/events/378.en.html DMS 1120 David Fetter