Skip site navigation (1)
Skip section navigation (2)
Bruce Momjian
Ten years ago, the software that had been Postgres made it out of the University of California at Berkeley, and emerged on the Internet as PostgreSQL. Bruce Momjian kicks off the conference with reflections on the intervening years and development.
Future of the Buildfarm Discussion
Andrew Dunstan
Following brief summary of the current architecture of the buildfarm, some plans to make it more modular, and possible functionality such as pre-application patch testing, optional test modules, and use in non-core projects, Andrew will lead an open discussion about which items will be of most use to the community.
Web Team Meeting
led by Dave Page
Meet with members of the PostgreSQL Web team as they discuss the plans and issues of www.postgresql.org. For contributors and want-to-be-contributors to the web site only.
Fundraising and Advocacy Meeting
JPUG Officers, PostgreSQL.Fr Officers, SPI Officers
Members of the PostgreSQL non-profit organizations each present briefly about their organization and its achivements over the last year. Then they will discuss how to coordinate global fundraising and organized advocacy efforts for PostgreSQL.
Neil Conway and Gavin Sherry
This workshop is a "walk-through" of the steps involved in making a non-trivial modification to PostgreSQL. The workshop is intended for people familiar with C programming, but who have not had much exposure to PostgreSQL internals. Attendees may wish to bring their laptops to follow along with the presenters.
Multi-threaded PostgreSQL
Zhiyong Peng
This describes an alteration to PostgreSQL using multiple processes and multiple threads. It works by establishing connections between the client and server through threads. The approach of one process per client is replaced by a process service pool.
Generic Monitoring/Tracing Framework for PostgreSQL
Robert Lor
This talk will discuss how to add a generic monitoring framework to PostgreSQL, to provide a common interface to PostgreSQL which can allow different operating systems to use their own monitoring or tracing technologies. Use and design of a DTrace implementation is discussed.
Performance
Scaling PostgreSQL on SMP Architectures
Doug Tolbert
This talk summarizes Unisys efforts to enhance scalability of PostgreSQL on 32-bit and 64-bit shared multiprocessor Linux platforms. We will discuss measurement methodologies, some scalability results,and possible future work items.
Bizgres and PostgreSQL Data Warehousing Features
Ayush Parashar
This presentation covers enhancements to PostgreSQL as a part of Bizgres development, including performance improvements due to enhancements in external sort, the copy command, and introduction of an on-disk bitmap index.
Performance Challenges and Goals Round-Table
Simon Riggs
Simon Riggs presents some viewpoints on performance: why we need it, how we can get it, plus a look back at 10 years of performance gains and a look ahead to industry trends that are going to shape our lives for the next 10 years. Heckling and general abuse encouraged.
The NTT Power Hour
Masao Fujii, Toru Shimogaki,Tetsuo Sakata, Takahiro Itagaki
The NTT staff present four projects NTT has been working on to enhance PostgreSQL performance. In this session, they will be open-sourcing new technology including a parallel database system, a high-speed loader, backup improvements and a new checkpoint algorithm.
Various PostgreSQL Hackers and Skype Staff
Join us for ten rapid-fire presentations of many of the diverse projects that make up the PostgreSQL universe, including TelegraphCQ, DBD::Pg, ORM, SNMP and more. Even more excitingly, Skype staff Hannu Krosing and Akso Oja will present two brand-new pieces of PostgreSQL technology. Other speakers are Hiroshi Saito, David Fetter, Greg Sabino Mullane, Neil Conway, Alvaro Herrera, Jean-Paul Argudo, Devrim Gunduz and "M".
Debugging PL/pgSQL
Korry Douglas and Jonah Harris
The PL/pgSQL debugger is a recently-released tool that allows users to debug PL/pgSQL. This talk discusses the architecture of PL/pgSQL, where the debugger fits, debugging requirements, and some use of the debugger.
XML Support: Specifications and Development
Peter Eisentraut
This talk will investigate the various ways in which "XML support" can be provided for PostgreSQL. The aim is to sort out the terminology and technology, as well as to encourage and justify current, past, and future developments.
Query By Example
Meredith Patterson
In an editorial on the future of databases, Jim Gray cites the need for "approximate querying." The QBE patch delivers a form of this for PostgreSQL. This talk discusses the patch, its implementation, and limitations, as well as outlining how QBE works in terms of support vector machines.
Databases in Research
Peter St. Onge
This talk will describe typical database problems in research we've encountered, particularly in biology, bioinformatics, and academia in general. We will present some of the PostgreSQL solutions (views, stored procedures, functions, materialized views) we've found to such problems.
Tsearch2 Development Round-Table
Oleg Bartunov and Teodor Sigaev
This talk describe the current state of the tsearch2 code, forthcoming features, and plans for future development. This includes discussion of utf-8, the query rewriting technique, and support for inverted index for better scaling.
Replication and Clustering
PGCluster Round Table
Atsushi Mitani
This discussion, led by Atsushi Mitani, will touch on some of the features of the PGCluster multimaster system, some of the motivations for its initiation, examine typical use cases, and solicit suggestions from the development community.
PgPool Development
Tatsuo Ishii
PgPool is a connection pool/replication server for PostgreSQL, which supports advanced features like load balancing and replication. Developers, working with the Japanese government, are now adding parallel query capability to pgPool.
Postgres-R: Theory and Demonstration
Bettina Kemme and Markus Schiltknecht
Postgres-R is a proof-of-concept eager replication system. The presenters cover recent developments in the research on the system, including integration with MVCC-capable PostgreSQL systems, recovery, writesets, group communication, concurrency, and testing.
Slony-I Team Meeting
led by Chris Browne
Members of the Slony-I team discuss their plans for 1.2.0 and beyond. Join them if you are a Slony contributor or hard-core user.
Peripheral Links
Header And Logo
|
Site Navigation
Catalog of Presentations
Catalog of PresentationsCommunity
KEYNOTE: Ten Years of PostgreSQLBruce Momjian
Ten years ago, the software that had been Postgres made it out of the University of California at Berkeley, and emerged on the Internet as PostgreSQL. Bruce Momjian kicks off the conference with reflections on the intervening years and development.
Future of the Buildfarm Discussion
Andrew Dunstan
Following brief summary of the current architecture of the buildfarm, some plans to make it more modular, and possible functionality such as pre-application patch testing, optional test modules, and use in non-core projects, Andrew will lead an open discussion about which items will be of most use to the community.
Web Team Meeting
led by Dave Page
Meet with members of the PostgreSQL Web team as they discuss the plans and issues of www.postgresql.org. For contributors and want-to-be-contributors to the web site only.
Fundraising and Advocacy Meeting
JPUG Officers, PostgreSQL.Fr Officers, SPI Officers
Members of the PostgreSQL non-profit organizations each present briefly about their organization and its achivements over the last year. Then they will discuss how to coordinate global fundraising and organized advocacy efforts for PostgreSQL.
Core Code
Introduction to Hacking PostgreSQL WorkshopNeil Conway and Gavin Sherry
This workshop is a "walk-through" of the steps involved in making a non-trivial modification to PostgreSQL. The workshop is intended for people familiar with C programming, but who have not had much exposure to PostgreSQL internals. Attendees may wish to bring their laptops to follow along with the presenters.
Multi-threaded PostgreSQL
Zhiyong Peng
This describes an alteration to PostgreSQL using multiple processes and multiple threads. It works by establishing connections between the client and server through threads. The approach of one process per client is replaced by a process service pool.
Generic Monitoring/Tracing Framework for PostgreSQL
Robert Lor
This talk will discuss how to add a generic monitoring framework to PostgreSQL, to provide a common interface to PostgreSQL which can allow different operating systems to use their own monitoring or tracing technologies. Use and design of a DTrace implementation is discussed.
Performance
Scaling PostgreSQL on SMP ArchitecturesDoug Tolbert
This talk summarizes Unisys efforts to enhance scalability of PostgreSQL on 32-bit and 64-bit shared multiprocessor Linux platforms. We will discuss measurement methodologies, some scalability results,and possible future work items.
Bizgres and PostgreSQL Data Warehousing Features
Ayush Parashar
This presentation covers enhancements to PostgreSQL as a part of Bizgres development, including performance improvements due to enhancements in external sort, the copy command, and introduction of an on-disk bitmap index.
Performance Challenges and Goals Round-Table
Simon Riggs
Simon Riggs presents some viewpoints on performance: why we need it, how we can get it, plus a look back at 10 years of performance gains and a look ahead to industry trends that are going to shape our lives for the next 10 years. Heckling and general abuse encouraged.
The NTT Power Hour
Masao Fujii, Toru Shimogaki,Tetsuo Sakata, Takahiro Itagaki
The NTT staff present four projects NTT has been working on to enhance PostgreSQL performance. In this session, they will be open-sourcing new technology including a parallel database system, a high-speed loader, backup improvements and a new checkpoint algorithm.
Extensions and Applications
Lightning TalksVarious PostgreSQL Hackers and Skype Staff
Join us for ten rapid-fire presentations of many of the diverse projects that make up the PostgreSQL universe, including TelegraphCQ, DBD::Pg, ORM, SNMP and more. Even more excitingly, Skype staff Hannu Krosing and Akso Oja will present two brand-new pieces of PostgreSQL technology. Other speakers are Hiroshi Saito, David Fetter, Greg Sabino Mullane, Neil Conway, Alvaro Herrera, Jean-Paul Argudo, Devrim Gunduz and "M".
Debugging PL/pgSQL
Korry Douglas and Jonah Harris
The PL/pgSQL debugger is a recently-released tool that allows users to debug PL/pgSQL. This talk discusses the architecture of PL/pgSQL, where the debugger fits, debugging requirements, and some use of the debugger.
XML Support: Specifications and Development
Peter Eisentraut
This talk will investigate the various ways in which "XML support" can be provided for PostgreSQL. The aim is to sort out the terminology and technology, as well as to encourage and justify current, past, and future developments.
Query By Example
Meredith Patterson
In an editorial on the future of databases, Jim Gray cites the need for "approximate querying." The QBE patch delivers a form of this for PostgreSQL. This talk discusses the patch, its implementation, and limitations, as well as outlining how QBE works in terms of support vector machines.
Databases in Research
Peter St. Onge
This talk will describe typical database problems in research we've encountered, particularly in biology, bioinformatics, and academia in general. We will present some of the PostgreSQL solutions (views, stored procedures, functions, materialized views) we've found to such problems.
Tsearch2 Development Round-Table
Oleg Bartunov and Teodor Sigaev
This talk describe the current state of the tsearch2 code, forthcoming features, and plans for future development. This includes discussion of utf-8, the query rewriting technique, and support for inverted index for better scaling.
Replication and Clustering
PGCluster Round TableAtsushi Mitani
This discussion, led by Atsushi Mitani, will touch on some of the features of the PGCluster multimaster system, some of the motivations for its initiation, examine typical use cases, and solicit suggestions from the development community.
PgPool Development
Tatsuo Ishii
PgPool is a connection pool/replication server for PostgreSQL, which supports advanced features like load balancing and replication. Developers, working with the Japanese government, are now adding parallel query capability to pgPool.
Postgres-R: Theory and Demonstration
Bettina Kemme and Markus Schiltknecht
Postgres-R is a proof-of-concept eager replication system. The presenters cover recent developments in the research on the system, including integration with MVCC-capable PostgreSQL systems, recovery, writesets, group communication, concurrency, and testing.
Slony-I Team Meeting
led by Chris Browne
Members of the Slony-I team discuss their plans for 1.2.0 and beyond. Join them if you are a Slony contributor or hard-core user.