2.0 -//Pentabarf//Schedule Final - we hope//EN PGCon2008 Schedule Release Final - we hope PGCon2008 Schedule PUBLISH 116@PGCon2008@pentabarf.org 116 yahoo Yahoo! drinks+food Join us for drinks, food, Yahoos, and Nintendo Wii. Let the games begin! English en 20080521T183000 20080521T233000 05H00M00S Yahoo! drinks+food- Join us for drinks, food, Yahoos, and Nintendo Wii. Let the games begin! Join us for drinks, food, Yahoos, and Nintendo Wii. Let the games begin! May 21, 2007 at 6:30 p.m. Urban Well, 244 Laurier Ave. East, Ottawa, Ontario Party on with Yahoo! and get your chance to win a FREE Wii! PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/116.en.html Urban Well Dan Langille PUBLISH 105@PGCon2008@pentabarf.org 105 hot HOT Inside The Technical Architecture English en 20080522T163000 20080522T173000 01H00M00S HOT Inside- The Technical Architecture This session will cover the technical architecture of HOT (Heap-Only-Tuples), a key feature of PostgreSQL 8.3. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/105.en.html B Pavan Deolasee PUBLISH 106@PGCon2008@pentabarf.org 106 pgpool2 pgPool2 Demonstrated English en 20080522T163000 20080522T173000 01H00M00S pgPool2 Demonstrated Tatsuo Ishii will show and explain how to use pgPool2, current project status, and planned features. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/106.en.html G Tatsuo Ishii PUBLISH 114@PGCon2008@pentabarf.org 114 dinner EnterpriseDB Dinner PGCon Dinner English en 20080522T190000 20080523T000000 05H00M00S EnterpriseDB Dinner- PGCon Dinner EnterpriseDB would like to invite the pgCon 2008 attendees to join them for an evening of food, drink and entertainment at the Velvet Room on the evening of the 22nd May. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/114.en.html Velvet Glove Dan Langille PUBLISH 107@PGCon2008@pentabarf.org 107 listen Listen/Notify How they work, and how they don't English en 20080523T113000 20080523T123000 01H00M00S Listen/Notify- How they work, and how they don't A description of how notifications currently work. LISTEN and NOTIFY commands. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/107.en.html A Andrew Dunstan PUBLISH 108@PGCon2008@pentabarf.org 108 nasa NASA Satellite Science Data Processing with PostgreSQL English en 20080522T150000 20080522T160000 01H00M00S NASA- Satellite Science Data Processing with PostgreSQL Over the last several decades, NASA has been one of the major collectors of Earth climate observations from space. The quantity of data from satellites has been exploding with the current generation producing hundreds of terrabytes of science data products each year. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/108.en.html A Curt Tilmes PUBLISH 115@PGCon2008@pentabarf.org 115 fripub Pub Night! Last chance for social intercourse before the Touristy stuff tomorrow English en 20080523T180000 20080523T230000 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/2008/schedule/events/115.en.html Royal Oak Pub Dan Langille PUBLISH 79@PGCon2008@pentabarf.org 79 pqg PgQ - generic high-performance queue for PostgreSQL how it is implemented, various uses English en 20080523T150000 20080523T160000 01H00M00S PgQ - generic high-performance queue for PostgreSQL- how it is implemented, various uses Queues in database are rarely used, because thus far is has been impossible to implement both robust and high-performance queue in general-purpose RDBMS. In PgQ we managed to solve this by generalizing snapshot-based event tracking first introduced with rserv, now used in Slony-I. This presentation will describe the implementation and also real-life use cases. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/79.en.html B Marko Kreen PUBLISH 72@PGCon2008@pentabarf.org 72 feedback Problems with PostgreSQL on Multi-core Systems with Multi-Terabyte Data Using customer feedback and benchmarks to reduce performance and productivity loss English en 20080522T150000 20080522T160000 01H00M00S Problems with PostgreSQL on Multi-core Systems with Multi-Terabyte Data- Using customer feedback and benchmarks to reduce performance and productivity loss As multi-core systems and storage space become cheaper, PostgreSQL is increasingly hard pressed to scale to the size of servers available to most users. Sun's performance engineers use customer feedback and industry standard benchmarks like TPC-E and SpecJAppserver to examine what causes these issues and what to do about them. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/72.en.html G Jignesh K. Shah PUBLISH 64@PGCon2008@pentabarf.org 64 pgrelease PostgreSQL Project and Release Management What Makes the Project Work English en 20080523T133000 20080523T143000 01H00M00S PostgreSQL Project and Release Management- What Makes the Project Work Core team member Peter Eisentraut gives a partially behind-the-scenes look at the processes that make the PostgreSQL project work. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/64.en.html G Peter Eisentraut PUBLISH 75@PGCon2008@pentabarf.org 75 search search.postgresql.org Using full text search for websites and mailing lists English en 20080522T163000 20080522T173000 01H00M00S search.postgresql.org- Using full text search for websites and mailing lists search.postgresql.org uses PostgreSQL Full Text Indexing to search mailinglists and websites. This talk will outline how it was built and deployed. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/75.en.html A Magnus Hagander PUBLISH 85@PGCon2008@pentabarf.org 85 projectman Some idle thoughts on PostgreSQL project management Why there is no traffic on replica-hooks-discuss English en 20080522T100000 20080522T110000 01H00M00S Some idle thoughts on PostgreSQL project management- Why there is no traffic on replica-hooks-discuss This is a talk about PostgreSQL feature development as observed over the past 7 years. Some features have been developed carefully, others have grown somewhat organically, and in some areas features continue to be an area of controversy. I explore the different strategies people take to developing these features, and make some suggestions on how the community might organise some future large feature development. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/85.en.html A Andrew Sullivan PUBLISH 101@PGCon2008@pentabarf.org 101 postgis PostGIS A Standards Based Geographic Extension for PostgreSQL English en 20080523T100000 20080523T110000 01H00M00S PostGIS- A Standards Based Geographic Extension for PostgreSQL A introduction is provided to PostGIS, a PostgreSQL extension for managing geographic feature (vector) data. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/101.en.html A Frank Warmerdam PUBLISH 78@PGCon2008@pentabarf.org 78 plproxy plProxy, pgBouncer, pgBalancer Paritioning databases and using remote calls English en 20080523T133000 20080523T143000 01H00M00S plProxy, pgBouncer, pgBalancer- Paritioning databases and using remote calls There are several ways how plProxy can be useful in case of large sets of online data. It was designed for partitioning databases but now we have taken it into use also for remote calls. pgBouncer is natural part of plProxy installations. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/78.en.html B Asko Oja PUBLISH 113@PGCon2008@pentabarf.org 113 drugs This is your PostgreSQL on drugs Secure enough for law enforcement English en 20080522T133000 20080522T143000 01H00M00S This is your PostgreSQL on drugs- Secure enough for law enforcement Do you have a large amount of data that needs to be searchable, aggregated and extremely secure at the same time? See many of the creative solutions that have been deployed to help facilitate how we put PostgreSQL to the task of drugs. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/113.en.html A Aaron Thul PUBLISH 60@PGCon2008@pentabarf.org 60 lightning PostgreSQL Lightning Talks Everyone gets 5 minutes of Fame! English en 20080522T173000 20080522T183000 01H00M00S PostgreSQL Lightning Talks- Everyone gets 5 minutes of Fame! The always enlightening, sometimes frightening, collection of talks from around the PostgreSQL community. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/60.en.html B Robert Treat PUBLISH 84@PGCon2008@pentabarf.org 84 accel Multi threaded query accelerator A case study English en 20080522T173000 20080522T183000 01H00M00S Multi threaded query accelerator- A case study Abstract: As the amount of data in the database grows more and more it becomes necessary in most of the applications using database to organize it in a way which is optimized for both high data insertion rate and faster query execution. This paper presents a case study which describes a database design which uses data partitioning to store huge data and a lightweight multi-threaded application which works as a middleware for faster query execution (up to 13 times). More emphasis is given on the multi-threaded application which executes queries spanning across multiple tables faster than only one single-threaded Postgres process. Approximately 90GB of data is going to be supported by this implementation with queries spanning across entire data. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/84.en.html A Durgaprasad S. Pawar PUBLISH 76@PGCon2008@pentabarf.org 76 sync Synchronous Log Shipping Replication High availability solution to minimize downtime English en 20080522T150000 20080522T160000 01H00M00S Synchronous Log Shipping Replication- High availability solution to minimize downtime NTT has developed a shared-nothing replication system for PostgreSQL implemented with transaction log shipping and Heartbeat. The goal is minimizing the system downtime and the impact for update performance. Failover can be done within 15 seconds and the overhead is at worst 7% on heavily-updated workloads in the current implementation. The replication solution realizes 99.999% availability so that it is applied to production systems. We will explain advantages of the solution and future direction of the development. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/76.en.html B ITAGAKI Takahiro PUBLISH 93@PGCon2008@pentabarf.org 93 bucardo Bucardo The open source multi-master replication system English en 20080523T160000 20080523T170000 01H00M00S Bucardo- The open source multi-master replication system Learn the strengths and weaknesses of Bucardo, an asynchronous multi-master replication system, and see a demo of it in action. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/93.en.html B Greg Sabino Mullane PUBLISH 98@PGCon2008@pentabarf.org 98 opening Opening Session Welcome back to PGCon and the Path to the Future English en 20080522T090000 20080522T100000 01H00M00S Opening Session- Welcome back to PGCon and the Path to the Future After a greeting by Dan, Bruce will consider possible future directions for the PostgreSQL software and the project. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/98.en.html B Bruce Momjian Dan Langille PUBLISH 99@PGCon2008@pentabarf.org 99 closing Closing Session Good bye and thanks for all the fish English en 20080523T170000 20080523T180000 01H00M00S Closing Session- Good bye and thanks for all the fish Closing Session PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/99.en.html B Dan Langille PUBLISH 90@PGCon2008@pentabarf.org 90 performance Researching PostgreSQL Performance Results from different OS and FS English en 20080523T150000 20080523T160000 01H00M00S Researching PostgreSQL Performance- Results from different OS and FS In this talk, we will present a detailed analysis of the scenarios tested (different loads and number of users). Furthermore, measurements reflecting improvements in the newer PostgreSQL version will be summarized. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/90.en.html G Fernando Ike PUBLISH 83@PGCon2008@pentabarf.org 83 logic Logic and Databases Answering complex questions & migrating data English en 20080522T113000 20080522T123000 01H00M00S Logic and Databases- Answering complex questions & migrating data This talk focuses on two common data management tasks, and how the relational model can help. First, how to answer complex questions about your data, and provide an answer that can be understood by non-IT people unambiguously. Second, how to effectively extract meaning from disorganized (or under-documented) data sets for effective data migration or reporting. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/83.en.html A Jeff Davis PUBLISH 110@PGCon2008@pentabarf.org 110 irods iRODS - A Large-Scale Rule-Orientated Data Management System RDBMS-based Data Grid, Persistent Archive, Digital Library English en 20080523T113000 20080523T123000 01H00M00S iRODS - A Large-Scale Rule-Orientated Data Management System- RDBMS-based Data Grid, Persistent Archive, Digital Library The integrated Rule Oriented Data management System (iRODS), is an open source software system that implements data grids, persistent archives, and digital libraries. iRODS incorporates an RDBMS for storing and querying persistent information and a distributed Rule Engine to invoke micro-service workflows. This session will present an overview of iRODS, how it makes use of PostgreSQL, and a comparison of PostgreSQL and Oracle iRODS instances. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/110.en.html B Wayne Schroeder PUBLISH 88@PGCon2008@pentabarf.org 88 dbilink DBI-Link 3.0 Federating Heterogeneous Data Stores - Using speadsheets and cvs files with databases English en 20080522T100000 20080522T110000 01H00M00S DBI-Link 3.0- Federating Heterogeneous Data Stores - Using speadsheets and cvs files with databases Have you ever needed to get data from a spreadsheet and put it in a database? Have you ever wanted to do real queries on a CSV file? DBI-Link 3.0 makes these operations easy. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/88.en.html B David Fetter PUBLISH 67@PGCon2008@pentabarf.org 67 java PostgreSQL: From a Java Enterprise Point of View Manipulating complex data models using component or object oriented methods English en 20080522T100000 20080522T110000 01H00M00S PostgreSQL: From a Java Enterprise Point of View- Manipulating complex data models using component or object oriented methods The Java Enterprise Edition specification defines APIs that allow developers to manipulate complex data models using component or object oriented methods. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/67.en.html G Jesper Pedersen PUBLISH 97@PGCon2008@pentabarf.org 97 patterns Database Anti-Patterns Everyone else is doing it wrong, why can't we? English en 20080521T130000 20080521T160000 03H00M00S Database Anti-Patterns- Everyone else is doing it wrong, why can't we? Many common solutions used in the world of database design go beyond sub-optimal to downright awful. Many times these pattern are carried over from early years of database design work, or learned from working on poorly implemented solutions. This talk we discuss many of the common faux pas, focusing not only on the bad, but hopefully providing better solutions to use in their place. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/97.en.html Fauteux 147B Robert Treat PUBLISH 111@PGCon2008@pentabarf.org 111 mysql What PostgreSQL could learn from MySQL The learning continues English en 20080522T133000 20080522T143000 01H00M00S What PostgreSQL could learn from MySQL- The learning continues While PostgreSQL was busy becoming the most advanced open source database, MySQL became the most popular. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/111.en.html G Susanne Ebrecht PUBLISH 86@PGCon2008@pentabarf.org 86 xbase Xbase++ meets PostgreSQL Migration of existing Xbase++, Clipper, FoxPro, Visual FoxPro or dBase applications to PostgreSQL English en 20080522T133000 20080522T143000 01H00M00S Xbase++ meets PostgreSQL- Migration of existing Xbase++, Clipper, FoxPro, Visual FoxPro or dBase applications to PostgreSQL An introduction into the Xbase++ language and how it supports the PostgreSQL server. This lecture is intended for programmers which have Xbase++, Clipper, FoxPro Visual FoxPro or dbase applications in the field. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/86.en.html B Steffen F. Pirsig PUBLISH 62@PGCon2008@pentabarf.org 62 oracle Porting Oracle Applications to PostgreSQL English en 20080520T130000 20080520T160000 03H00M00S Porting Oracle Applications to PostgreSQL Learn about the issues surrounding porting database applications to PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/62.en.html Fauteux 147B Peter Eisentraut PUBLISH 69@PGCon2008@pentabarf.org 69 views Materialized Views that Really Work How to simply leverage view materialization for even the most complex cases English en 20080521T090000 20080521T120000 03H00M00S Materialized Views that Really Work- How to simply leverage view materialization for even the most complex cases Gain huge performance boosts for your applications with Materialized Views. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/69.en.html Fauteux 147B Dan Chak PUBLISH 103@PGCon2008@pentabarf.org 103 tourist Tourist Time See the sights in and/or around Ottawa English en 20080524T093000 20080524T143000 05H00M00S Tourist Time- See the sights in and/or around Ottawa Play Tourist PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/103.en.html Out and about Dan Langille PUBLISH 102@PGCon2008@pentabarf.org 102 registration Registration pickup The social way to register: at the pub English en 20080521T150000 20080521T200000 05H00M00S Registration pickup- The social way to register: at the pub Pick up your registration pack PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/102.en.html Royal Oak Pub Dan Langille PUBLISH 87@PGCon2008@pentabarf.org 87 upgrade PostgreSQL upgrade project Upgrade on-the-fly or with minimal down time. English en 20080523T160000 20080523T170000 01H00M00S PostgreSQL upgrade project- Upgrade on-the-fly or with minimal down time. Upgrade from old PostgreSQL version to the new is now possible only through data export and import. PG upgrade is a project which should allow to upgrade database on-fly or with minimal down time. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/87.en.html G Zdeněk Kotala PUBLISH 77@PGCon2008@pentabarf.org 77 sepostgresql Security-Enhanced PostgreSQL "System-wide consistency" in access control English en 20080523T113000 20080523T123000 01H00M00S Security-Enhanced PostgreSQL- "System-wide consistency" in access control SE-PostgreSQL is a security extension built-in PostgreSQL, collaborating with SELinux. The purpose is to achieve "system-wide consistency" in access control, with applying fine-grained mandatory access control to various database objects such as tables, columns and tuples. This feature enables to deploy a database management system within information flow control scheme integrated with operating system. It helps protect our information asset from some of threats like leaking, defacting and destruction. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/77.en.html G KaiGai Kohei PUBLISH 58@PGCon2008@pentabarf.org 58 inverted Improvement of Generalized Inverted Index Multicolumn index support and speedup of index update English en 20080522T113000 20080522T123000 01H00M00S Improvement of Generalized Inverted Index- Multicolumn index support and speedup of index update We present new multicolumn feature support of the Generalized Inverted Index (GIN) and intermediate results of our research on fast online GIN update. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/58.en.html G Oleg Bartunov Teodor Sigaev PUBLISH 96@PGCon2008@pentabarf.org 96 dracones Dracones A PostgreSQL/MapServer WebGIS application for Public Health Surveillance English en 20080523T133000 20080523T143000 01H00M00S Dracones- A PostgreSQL/MapServer WebGIS application for Public Health Surveillance We make extensive use of PostgreSQL and its spatial extension PostGIS. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/96.en.html A Christian Jauvin PUBLISH 74@PGCon2008@pentabarf.org 74 windows Deploying PostgreSQL in a Windows Enterprise Integrating with Windows and Active Directory English en 20080523T100000 20080523T110000 01H00M00S Deploying PostgreSQL in a Windows Enterprise- Integrating with Windows and Active Directory Many larger networks are based around Windows and Active Directory. This talk will show how PostgreSQL can integrate and work with such existing environments. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/74.en.html B Magnus Hagander PUBLISH 66@PGCon2008@pentabarf.org 66 npgsql Introducing Npgsql A .Net Data Provider for Postgresql English en 20080523T160000 20080523T170000 01H00M00S Introducing Npgsql- A .Net Data Provider for Postgresql This presentation will introduce Npgsql, a .Net data provider for Postgresql written in 100% C# code. Npgsql allows programs written for .Net Runtime to access postgresql database servers. It can be run on GNU/Linux, Windows, MacOS and any other platform which has a .Net runtime available. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/66.en.html A Hiroshi Saito Francisco Figueiredo Jr. Josh Cooley PUBLISH 57@PGCon2008@pentabarf.org 57 archives Horizontal Scalability with PostgreSQL Archival of digital data English en 20080522T113000 20080522T123000 01H00M00S Horizontal Scalability with PostgreSQL- Archival of digital data The Hitachi Content Archive Platform (HCAP) is a storage system designed for the archival of digital data. HCAP software runs on a cluster of Linux nodes, implementing a shared nothing architecture. File metadata is kept in a set of Postgres databases, one running on each node of the cluster. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/57.en.html B Jack Orenstein PUBLISH 95@PGCon2008@pentabarf.org 95 htsql HTSQL - a web-based front-end for PostgreSQL An innovative URL-2-SQL translator for Web 2.0 applications. English en 20080523T150000 20080523T160000 01H00M00S HTSQL - a web-based front-end for PostgreSQL- An innovative URL-2-SQL translator for Web 2.0 applications. With the proliferation of web-based applications and increased user technical ability, distributed applications with multiple front-ends becomes a viable, if not essential approach to software construction and deployment. This talk will describe an approach to web-based databases, specifically a URL-2-SQL translator which converts common assumptions about how web resources should work into SQL queries for a PostgreSQL backend. Interestingly enough, with a tool such as HTSQL together with the maturity of database-level constraints and stored procedures, the pendulum favoring 3-tier solutions swings back to a 2-tier approach. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/95.en.html A Clark Evans PUBLISH 59@PGCon2008@pentabarf.org 59 searches Approximate Search Similarity searches in Postgresql using metric spaces English en 20080523T100000 20080523T110000 01H00M00S Approximate Search- Similarity searches in Postgresql using metric spaces A way to realize similarity searches between objects as words, sounds, images, etc.. using metric spaces. It is a way to do range queries, nearest neighboor queries and K-nearest neighboor queries. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/59.en.html G Enrico Pirozzi PUBLISH 104@PGCon2008@pentabarf.org 104 guc_tour GUCs: A Three Hour Tour Every option, explained English en 20080520T090000 20080520T120000 03H00M00S GUCs: A Three Hour Tour- Every option, explained PostgreSQL now has 187 GUCs, most of which are server configuration settings, and begins to rival Oracle in complexity of administrator options. Take a high-speed tour of all of the options with core team member Josh Berkus. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2008/schedule/events/104.en.html Fauteux 147B Josh Berkus