2.0 -//Pentabarf//Schedule Confirmed//EN PGCon2007 Schedule Release Confirmed PGCon2007 Schedule PUBLISH 54@PGCon2007@pentabarf.org 54 Advanced PostgreSQL on Windows Looking at Windows specific issues for PostgreSQL deployment and development English en 20070523T163000 20070523T173000 1H

Advanced PostgreSQL on Windows - Looking at Windows specific issues for PostgreSQL deployment and development

An overview of PostgreSQL on Windows, one our fastest growing platforms. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/54.en.html SITE A0150 Magnus Hagander PUBLISH 56@PGCon2007@pentabarf.org 56 closing Closing Sessions Famous Last Words + prizes to give away English en 20070524T160000 20070524T163000 0H

Closing Sessions - Famous Last Words + prizes to give away

A few closing words and thanks. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/56.en.html SITE H0104 Dan Langille PUBLISH 53@PGCon2007@pentabarf.org 53 Developing New Zealand's Electoral Roll on PostgreSQL Success Story: running New Zealand's Electoral Roll on PostgreSQL English en 20070523T163000 20070523T173000 1H

Developing New Zealand's Electoral Roll on PostgreSQL - Success Story: running New Zealand's Electoral Roll on PostgreSQL

The New Zealand Electoral Roll was migrated from Oracle to PostgreSQL in 2002 by Catalyst IT.This deployment coincided with a total rewrite of the system. In this talk I will discuss how and why PostgreSQL was selected, how we have used PostgreSQL to support continuous development and where we would like to go in the near future. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/53.en.html SITE G0103 Finlay Thompson PUBLISH 15@PGCon2007@pentabarf.org 15 fairuse Digesting an open-source fair-use TPC-E implementation. TPC-E is the new On-Line Transaction Processing workload being developed by the Transaction Processing Performance Council (TPC). It is intended to replace the aging TPC-C. English en 20070523T133000 20070523T143000 1H

Digesting an open-source fair-use TPC-E implementation. - TPC-E is the new On-Line Transaction Processing workload being developed by the Transaction Processing Performance Council (TPC). It is intended to replace the aging TPC-C.

This talk starts by describing the TPC-E specification in high-level terms and reasoning why TPC-E represents modern database server workload. It continues by explaining the benefits to the open source development community (particularly to the PostgreSQL community) of counting on an open-source workload based on the industry-standard TPC-E benchmark. The implementation and architecture of the workload are outlined and motivating experimental results are presented. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/15.en.html SITE G0103 Mark Wong Rilson Nascimento PUBLISH 21@PGCon2007@pentabarf.org 21 execution Execution plan optimization techniques Execution plan optimization techniques and possible improvements in PostgreSQL implementation English en 20070523T113000 20070523T123000 1H

Execution plan optimization techniques - Execution plan optimization techniques and possible improvements in PostgreSQL implementation

We will shortly describe and explain the problem of cost based execution plan optimization. We will focus primarily on algorithms for searching the space of all possible alternatives for the large number of joins. We will briefly describe these algorithms and their possible variants, compare them together and we will try to pick up some of them as suitable for solving our problem. Some examples of execution of these algorithms on the traveling salesman problem will be shown. The traveling salesman problem was chosen for the presentation because it is a very similar problem and much easier to imagine and present than searching the space of execution plan alternatives. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/21.en.html SITE G0103 Tomas Kovarik Julius Stroffek PUBLISH 13@PGCon2007@pentabarf.org 13 fulltext Full Text Search in PostgreSQL New version of built-in FTS will be enlighted and demonstrated English en 20070523T113000 20070523T123000 1H

Full Text Search in PostgreSQL - New version of built-in FTS will be enlighted and demonstrated

We present the new version of Full Text Search in PostgreSQL. It's a tsearch2 module now integrated into PostgreSQL core with many improvements and additions. It features many languages support available on default, SQL interface to the FTS objects, improved documentation and schema-based support of multiple configurations. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/13.en.html SITE B0138 Oleg Bartunov PUBLISH 22@PGCon2007@pentabarf.org 22 gin GIN in practice Developing extensions for GIN index English en 20070523T150000 20070523T160000 1H

GIN in practice - Developing extensions for GIN index

Usage of GIN index - an idea, usefulness, applicability. Description of GIN interface. As an example, developing GIN extension for hstore contrib module. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/22.en.html SITE A0150 Teodor Sigaev PUBLISH 18@PGCon2007@pentabarf.org 18 keynote Great Steps in PostgreSQL History A review of the developments which grew the PostgreSQL community English en 20070523T090000 20070523T100000 1H

Great Steps in PostgreSQL History - A review of the developments which grew the PostgreSQL community

Despite some hit-and-miss development efforts, PostgreSQL has kept jumping ahead, both in community and features. Bruce Momjian reviews a few of our "great leaps forward", and what led up to them. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/18.en.html SITE B0138 Bruce Momjian PUBLISH 4@PGCon2007@pentabarf.org 4 view Improving Your View The Upcoming Role of PostgreSQL in Flat Panel Display Production English en 20070524T100000 20070524T110000 1H

Improving Your View - The Upcoming Role of PostgreSQL in Flat Panel Display Production

TCZ, a joint venture between Cymer and Carl Zeiss SMT, is focused on developing innovative production equipment for the emerging flat panel display (FPD) market. This presentation is a case study that will show the many ways PostgreSQL is utilized as a critical component of the Master System Controller for the TCZ 900X system. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/4.en.html SITE A0150 Joe Conway PUBLISH 8@PGCon2007@pentabarf.org 8 pgintrohacking Introduction to Hacking PostgreSQL English en 20070521T090000 20070521T120000 3H

Introduction to Hacking PostgreSQL

An introduction to how to modify the PostgreSQL source code. This tutorial is intended for programmers with some knowledge of C, who would like to understand how PostgreSQL works and how to modify it. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/8.en.html SITE F0126 Neil Conway PUBLISH 23@PGCon2007@pentabarf.org 23 academia Migrating to PostgreSQL in Academia Moving legacy data and applications to PostgreSQL for a large University English en 20070523T150000 20070523T160000 1H

Migrating to PostgreSQL in Academia - Moving legacy data and applications to PostgreSQL for a large University

Large academic institutions often have data collected in many different database systems that has to be collected for administrative use. This lecture will be a discussion of issues raised and techniques learned while migrating the academic advising system for the Franklin College Office of Academic Advising (responsible for advising undergraduates at the largest college of The University of Georgia) from a home-grown FileMaker Pro-based system to an award-winning web application built with PHP and PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/23.en.html SITE B0138 Michael Brewer PUBLISH 17@PGCon2007@pentabarf.org 17 oracle Oracle to PostgreSQL Conversion English en 20070523T100000 20070523T110000 1H

Oracle to PostgreSQL Conversion

Transition from Oracle to a PostgreSQL database can be confusing. This presentation provides someone new to PostgreSQL with many of the differences they will need to overcome and some tricks to do so. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/17.en.html SITE A0150 Brian Dunavant PUBLISH 45@PGCon2007@pentabarf.org 45 whack Performance Whack-a-Mole Methodology for troubleshooting database application performance English en 20070521T130000 20070521T160000 3H

Performance Whack-a-Mole - Methodology for troubleshooting database application performance

Core team member Josh Berkus will take you through his step-by-step method for analyzing and troubleshooting database application performance bottlenecks. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/45.en.html SITE F0126 Josh Berkus PUBLISH 6@PGCon2007@pentabarf.org 6 cluster PGCluster-II Clustering system of PostgreSQL that is using shared data English en 20070524T133000 20070524T143000 1H

PGCluster-II - Clustering system of PostgreSQL that is using shared data

PGCluster-II is a shared-disk based clustering system for PostgreSQL, implemented with virtual IPC for session and lock management. It supports both high availability and load balancing needs. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/6.en.html SITE H0104 Atsushi Mitani PUBLISH 19@PGCon2007@pentabarf.org 19 pgsnmpd pgsnmpd Keeping tabs on PostgreSQL English en 20070524T113000 20070524T123000 1H

pgsnmpd - Keeping tabs on PostgreSQL

pgsnmpd is a net-snmp-based monitoring daemon being developed for PostgreSQL 8.x. Initial versions will support RFC 1697 (http://www.faqs.org/rfcs/rfc1697.html) and the associated RDMBS-MIB on Linux, but future versions will include an expanded MIB to keep track of all kinds of useful information. We will demonstrate pgsnmpd as well as its interaction with a few common software packages to provide realtime alerts and display historical trends. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/19.en.html SITE H0104 Joshua Tolley PUBLISH 31@PGCon2007@pentabarf.org 31 plperl Pl/Perl - Best of Both Worlds Learn how Pl/Perl can make you more productive English en 20070522T130000 20070522T160000 3H

Pl/Perl - Best of Both Worlds - Learn how Pl/Perl can make you more productive

Learn all about Pl/Perl, which combines the best language with the best database. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/31.en.html SITE F0126 Greg Sabino Mullane PUBLISH 24@PGCon2007@pentabarf.org 24 education PostgreSQL in Education BOF A meeting for conference attendees using PostgreSQL in academia English en 20070523T180000 20070523T200000 2H

PostgreSQL in Education BOF - A meeting for conference attendees using PostgreSQL in academia

This meeting is intended to gather conference attendees who use (or are interested in using) PostgreSQL in education. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/24.en.html SITE B0138 Michael Brewer PUBLISH 52@PGCon2007@pentabarf.org 52 pginside PostgreSQL Inside Choosing the World's Most Advanced Open Source Database for EnterpriseDB English en 20070523T150000 20070523T160000 1H

PostgreSQL Inside - Choosing the World's Most Advanced Open Source Database for EnterpriseDB

PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/52.en.html SITE G0103 Denis Lussier PUBLISH 50@PGCon2007@pentabarf.org 50 lightning PostgreSQL Lightning Talks Everyone gets 5 minutes of fame English en 20070524T150000 20070524T160000 1H

PostgreSQL Lightning Talks - Everyone gets 5 minutes of fame

PostgreSQL Related Lightning Talks, contributed from the community. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/50.en.html SITE H0104 Robert Treat PUBLISH 37@PGCon2007@pentabarf.org 37 palaver PostgreSQL Palaver / Keysigning Moderated and wide-ranging discussion of issues facing the community (followed by keysigning party) 20070523T180000 20070523T200000 2H

PostgreSQL Palaver / Keysigning - Moderated and wide-ranging discussion of issues facing the community (followed by keysigning party)

The PostgreSQL project has grown faster than anyone involved early on could have imagined. While we are doing a great job, there is always room for improvement. This will be a wide-ranging discussion and brainstorming session about any and all problems and issues regarding the project - not just technical, but all other aspects as well. Topics and questions are encouraged to be submitted in advance. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/37.en.html SITE A0150 Greg Sabino Mullane PUBLISH 41@PGCon2007@pentabarf.org 41 partitioning PostgreSQL Partitioning Slicing and dicing your schema for quicker queries and dishing data English en 20070523T113000 20070523T123000 1H

PostgreSQL Partitioning - Slicing and dicing your schema for quicker queries and dishing data

Begining in 8.1, PostgreSQL has offered table partitioning, allowing you to split data across different physical segments for significant performance improvements. While the feature is simple to get into, manageing large table partition setups can prove tricky to the beginer. In this tutorial we will discuss many of the insider tricks that are used in todays largest setups and talk about what the documentation leaves out. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/41.en.html SITE A0150 Robert Treat PUBLISH 47@PGCon2007@pentabarf.org 47 performance PostgreSQL performance research Better. Faster. Stronger. English en 20070524T150000 20070524T160000 1H

PostgreSQL performance research - Better. Faster. Stronger.

A review of advances in PostgreSQL performance for Release 8.3, pluslonger term opportunities and requirements. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/47.en.html SITE A0150 Simon Riggs PUBLISH 20@PGCon2007@pentabarf.org 20 replicationstrategy PostgreSQL replication strategies Understanding High Availability and choosing the right solution English en 20070523T133000 20070523T143000 1H

PostgreSQL replication strategies - Understanding High Availability and choosing the right solution

This talk introduces the key aspects you need to consider when building Highly Available solutions based on PostgreSQL. Current key replication and clustering technologies for PostgreSQL are presented to show how they address issues such as load balancing, performance scalability, failover/failback and upgradeability. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/20.en.html SITE A0150 Emmanuel Cecchet PUBLISH 30@PGCon2007@pentabarf.org 30 pg8 PostgreSQL Version 8 in action Real-world examples showing useful features added in 8.0, 8.1, and 8.2 English en 20070524T133000 20070524T143000 1H

PostgreSQL Version 8 in action - Real-world examples showing useful features added in 8.0, 8.1, and 8.2

Are you taking advantage of the latest advancements in PostgreSQL? If you aren't using 8.2, see whatyou are missing out on. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/30.en.html SITE A0150 Greg Sabino Mullane PUBLISH 55@PGCon2007@pentabarf.org 55 image PostgreSQL-IE An Image-Handling Extension to support Content-based Image Retrieval English en 20070523T100000 20070523T110000 1H

PostgreSQL-IE - An Image-Handling Extension to support Content-based Image Retrieval

PostgreSQL-IE is an extension to PostgreSQL to support content-based image retrieval. The extension makes available a new image data type, and extends the Structured Query Language – SQL with new functions that are able to create new feature descriptors, new feature vectors as combinations of previously defined features, new access methods, and to pose similarity queries. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/55.en.html SITE G0103 Denise Guliato PUBLISH 9@PGCon2007@pentabarf.org 9 porting Practical experience with moving applications to PostgreSQL Porting challanges: Database design, human factor English en 20070523T133000 20070523T143000 1H

Practical experience with moving applications to PostgreSQL - Porting challanges: Database design, human factor

Practical experience with redesigning and moving applications from MSSQL, Paradox and Access to PostgreSQL. Pinpoint challenges in database design, data migration, propagation of PostgreSQL inside company (human factor), introduction to novice developer(s), database GUI tools (CASE, SQL editors, graphical query builder, administration tools). PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/9.en.html SITE B0138 Radovan Jablonovsky PUBLISH 43@PGCon2007@pentabarf.org 43 dba101 Pro PostgreSQL DBA 101 For the PostgreSQL Crowd English en 20070522T090000 20070522T120000 3H

Pro PostgreSQL - DBA 101 For the PostgreSQL Crowd

Tips and tricks for running PostgreSQL Databases in a production environment. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/43.en.html SITE F0126 Robert Treat PUBLISH 16@PGCon2007@pentabarf.org 16 smp Scaling PostgreSQL on SMP Architectures -- An Update English en 20070523T100000 20070523T110000 1H

Scaling PostgreSQL on SMP Architectures -- An Update

Updates last year's 10th Anniversary Summit presentation on Unisys efforts to enhance scalability of PostgreSQL on 32-bit and 64-bit shared multiprocessor Linux platforms. Measurements reflecting improvements in newer PostgreSQL releases are summarized and possible strategies for further improvement are discussed. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/16.en.html SITE B0138 Doug Tolbert PUBLISH 12@PGCon2007@pentabarf.org 12 streaming Stream Processing with PostgreSQL An Introduction to Data Streams and TelegraphCQ English en 20070524T113000 20070524T123000 1H

Stream Processing with PostgreSQL - An Introduction to Data Streams and TelegraphCQ

An introduction to data stream query processing. Traditional database systems use a "store and query" model: the data is stored by the DBMS, and one-time queries are submitted, evaluated, and then the results returned to clients. This model is often inappropriate for a world in which data is constantly in motion. For applications like network monitoring, real-time financial analysis, and sensor networks, the overhead required to store data to disk and then compute a one-time query is excessive. A data stream management system (DSMS) allows long-running continuous queries over data streams to be defined, yielding a query processing model much more amenable to real-time analysis and response. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/12.en.html SITE A0150 Neil Conway PUBLISH 14@PGCon2007@pentabarf.org 14 xml The Road to the XML Type English en 20070524T100000 20070524T110000 1H

The Road to the XML Type

In this talk we will present the roadmap for the development of native XML type support in PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/14.en.html SITE H0104 Nikolay Samokhvalov Peter Eisentraut PUBLISH 46@PGCon2007@pentabarf.org 46 solaris Useful Solaris tools for PostgreSQL DBAs Five Solaris components you can use to improve PostgreSQL reliability and availability English en 20070523T163000 20070523T173000 1H

Useful Solaris tools for PostgreSQL DBAs - Five Solaris components you can use to improve PostgreSQL reliability and availability

Sun engineers Robert Lor, Jim Gates, Zdenek Kotala, Julius Stroffek and Josh Berkus will present five features of Solaris Nevada which can be extremely useful to PostgreSQL DBAs. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2007/schedule/events/46.en.html SITE B0138 Robert Lor Josh Berkus