Programmes（2nd day）

Time

10:00 - 10:25 (25 minutes)

Abstract

PostgreSQL is one of the oldest and most successful opensource projects, it has an avid worldwide community with thousends of people discussing on mailinglists and forums, hundreds of developers contribution code and patches every release and a huge userbase that needs to stay informed and supported.

Often underestimated and usually invisible (except when it breaks down) it is the worldwide hosted infrastructure that enables a project as large as this to work effectively.

However it is rarely known in the wider community how all the bits work together and what else there is beside the website, the mailing lists and the main cvs repository.

This talk aims at providing answers to what the infrastructure consists of, how and by whom it is managed as well as giving an inside view on what we plan to do in the future.

Profile

Stefan Kaltenbrunner is a "major contributor" to the PostgreSQL opensource project working on the projects server and software infrastructure as well as the website.

Aside from his duties as part of the sysadmin team, he is also doing regular benchmarking and regression testing of PostgreSQL and related tools. During paid daytime,he is a Senior Systems Engineer for conova communications GmbH in Salzburg/Austria, an IT consulting and service company providing services through its own datacenter.

Time

10:25 - 10:50 (25 minutes)

Abstract

"Hinemos" is an OSS operational management tool which uses PostgreSQL as its database. From the beginning of its Development, we have seeked to use PostgreSQL more efficiently and more effectively, and have added changes to them.

Profile

After entering the research and development of the distributed and parallel database using PostgreSQL, has commited in verifying large-scale systems using PostgreSQL. Committing the Development of PostgresForest from 2006, Hinemos from 2008, and today not only take part in development, but also in maintenance and wide spreading of both Hinemos and PostgresForest.

This presentation will introduce some cases of PostgreSQL tuning taken in the development of Hinemos, Changes in "Hinemos" with the new version of PostgreSQL, and some cases of Clustering, using PostgreSQL in Hinemos.

Time

11:00 - 11:50 (50 minutes)

Abstract

In a fantasy world Postgres never has bugs, hardware never fails, and DBAs never use faulty backup procedures. However in the real world any of these circumstances can lead to data corruption. We analyse the typical symptoms caused by these different failure modes and the common strategies used to repair databases when a clean restore is impossible.

Profile

Greg Stark has been working with and on PostgreSQL since 2001. His committed patches included top-k sort optimization, storage density improvements, and asynchronous I/O support for bitmap heap scans.

Time

12:05 - 12:45 (40 minutes)

Abstract

CakePHP/PostgreSQL

This talk will provide the construction case and Tips that combines CakePHP with PostgreSQL.

A lot of use examples by MySQL are introduced in an overseas framework including CakePHP. However, the support is done, and various DB can be used also with PostgreSQL unquestionably in CakePHP. Up to now, it has explained the case with the system that actually constructs it with the experience of constructing a lot of systems with the combination of CakePHP and PostgreSQL and the finding obtained then.

CakePHP/Slony-I + pgpool-II

In addition, it introduces the knowhow used from construction, operation, and CakePHP of the DB replication composition with Slony-I and pgpool-II as an application example.

Profile

1x1 Inc. CEO

It is involved in a lot of Web construction of a systems with PHP and PostgreSQL. The charm of CakePHP that it is in such, and is PHP framework is possessed, and communities of the announcement in writing blog and the book and study meetings and management, etc. act besides on business using it since then.

Books

"CakePHP guide book", "Practice Web application development by CakePHP', and "CakePHP1.2 guide book"

Time

12:45 - 13:05 (20 minutes)

Abstract

The speaker is now working for a SME, and he will talk about his experience to introduce PostgreSQL at his company.

Generally speaking, SMEs have no enough IT human resource, as well as money budgets, that makes it very hard for such SME to introduce IT environment within the organization.

He had good knowledge about Open Source Software, and felt big potential about OSS RDBMS when he came upon PostgreSQL in 2001.

The speaker installed PostgreSQL and studied commands, made simple systems with PostgreSQL, etc., but he regretted that he did not have deeper knowledge about RDBMS, like PostgreSQL. Facing to that situation, he began to study RDBMS hardly, and now, the speaker is capable to build e-commerce sites with the search capability using PostgreSQL.

Profile

Born in 1973 in Osaka. After graduated from the university, I was engaged in the current SME, to whom I introduced OSS. Now, I am reserching the best model how to introduce IT into SME.

David Wheeler

* material (PDF/8.5MB)
* Ustream

Time

13:20 - 14:10 (50 minutes)

Abstract

We're all used to unit testing our applications by now. The Extreme and Agile programming movements have done a great deal to promote unit testing, to the extent that many of us are now dependent on tests to assure that our applications work reliably. But how often do we test the database underlying our applications? Given that the database, as the repository for all of the knowledge and data for an application, just might be the single most important part of that application, the time for standardized database unit testing has come.

This talk promotes the practice of writing and running unit tests that directly test the schema, storage, and functionality of application databases. Following a review of the available PostgreSQL unit testing frameworks, we'll look at examples of testing tables, views, columns, constraints, indexes, triggers, and functions. The idea is to promote complete test coverage every aspect of a database, independent of application unit tests, to ensure reliably canonical data integrity.

Profile

David E. Wheeler is really excited about testing, and about database testing in particular. He is responsible for pgTAP, a unit-testing framework for PostgreSQL.

David E. Wheeler is:

• The maintainer for Bricolage, an open-source content management and publishing system that runs on Apache/mod_perl and PostgreSQL.
• Founder and President of Kineticode, provider of Bricolage consulting and support services.
• Co-Founder and Associate at pgExperts, provider of PostgreSQL database and application development services.
• Former CTO of Values of n, creators of Stikkit and I Want Sandy, Ruby on Rails applications that ran on MySQL and PostgreSQL, respectively.
• A technology blogger.
• Creator and maintainer of pgTAP, a unit-testing framework for PostgreSQL.
• Creator and maintainer of numerous CPAN modules.
• Contribuor of the CITEXT data type.
• A photographer, tennis player, wine and food lover, father.

Links

• Blog
• Kineticode, Inc.
• pgTAP

Time

14:20 - 15:10 (50 minutes)

Abstract

Nowadays, most of security incidents happen on the web system complexed with databases. It is obvious that we can't be wait anymore to restructure our security infrastructure, especially, with the movement of SaaS and Cloud computing.

This session introduce the background, features and usages of LAPP/SELinux which is a secure web application platform using SELinux, SE-PostgreSQL and Apache/SELinux plus. In addition, we can provide a demonstration of LAPP/SELinux to show how it improves security on the complexed system.

Profile

KaiGai Kohei has been worked in NEC since 2003, and been a SELinux developer for more than five years. He improved scalability of SELinux in large SMP system, ported XATTR feature into JFFS2 filesystem and so on. Now, he focuses on development of LAPP/SELinux stack centering on SE-PostgreSQL for the recent two years. He was also commended by METI and IPA as a genuis-programemr due to the development of SE-PostgreSQL at 2007.

Time

15:20 - 16:10 (50 minutes)

Abstract

In the SQL standard, 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.

We can make Common Table Expressions even more powerful than the current SQL standard allows. We might even make it part of a future SQL standard.

Old syntax:

WITH [RECURSIVE] cte1 [(col[, col...])] AS (
       READ_QUERY
   [(UNION|INTERSECT) [ALL]
       READ_QUERY
   )[, cte2 ...]
   SELECT ...

New syntax:

WITH [RECURSIVE] cte1 [(col[, col...])] AS (
       ROW_RETURNING_QUERY /* for example, DELETE...RETURNING */
   [(UNION|INTERSECT) [ALL]
       ROW_RETURNING QUERY
   )[, cte2 ...]
   SELECT... 

Profile

David Fetter is based in the San Francisco Bay Area and has worked in various commercial enterprises, non-profits and educational institutions. He has worked extensively with PostgreSQL, Oracle, MySQL, Perl, PHP, PL/SQL, PL/PgSQL, PL/Perl and (of course!) vim on transaction processing and business intelligence systems.

In his free time, he brews beer, rides his bicycle, and helps run several organizations for computer professionals including the Oakland Perl Users' Group, the San Francisco PostgreSQL Users' Group and the San Francisco Perl Users' Group.

Time

10:00 - 10:25 (25 minutes)

Abstract

PGCluster is a multi-master and synchronous replication system for PostgreSQL. The latest version of PGCluster has new features as follows.

(1) Automated build the synchronous replication environment

In order to build cluster DB as a synchronous repilication system, it needs to setup the consistent configuration for all servers. It is not easy way. The more servers set up the more complex configurations. This feature generate consistent configuration files for all servers by minumun setup.

(2) Automated restore faulted server to replication environment

In order to keep stable DB system, operators monitor and maintenance it 24h-7d as mandatory activity. The latest PGCluster having auto monitoring and auto recovery function. And it works as a seamless integration.

(3) Portable Cluster DB

Some mobile users demand to use cluster DB beyond the reach of the network. This feature syncs data for all DBs after connected the portal cluster DB, and execute accumulated queries during it was standalone.

Profile

Atsushi has developed and maintained PGCluster which is a synchronous multi-master replication system for PostgreSQL since 2001.

He has taken an active part in a Europe Open Source conference during he had worked in the Netherlands for 2005 - 2007.

Now, he is planing to develop the clustering system and the grid system of PostgreSQL which uses a partial shared data not a replication.

Time

10:25 - 10:50 (25 minutes)

Abstract

pgpool-II is a middleware that works between PostgreSQL servers and a client. pgpool-II provides connection pooling, replication and load balancing functions. Business use of pgpool-II has been expanding the last few years, because pgpool-II enables higher performance and higher availability compared to a single PostgreSQL server.

In this session, we explain the latest information of pgpool-II, such as the overview, recent updates and the case study with pgpool-II. In addition, we introduce the combination of pgpool-II, synchronous replication and hot standby functions in PostgreSQL 8.5.

Profile

Yoshiharu Mori works for SRA OSS, Inc. Japan. He is a PostgreSQL consultant and support enginner.

Time

11:00 - 11:50 (50 minutes)

Abstract

It has been 11 years since XML was developed and the support of XML standard continues in the world of database as well. In such circumstance, PostgreSQL8.4 implements XML functions which are equivalent to other commercial databases and it has reached the level where it can be fully put to practical use as XML system.

The presentation gives a broad overview of PostgreSQl 8.4 starting from its basic operations such as storage and retrieval of XML data, followed by the method of applying index function, which is fundamental in database operation, to XML, and furthermore, its additional supplied module XML2 which supports XSLT, a significant transformational technology.

In explaining functions, utilization methods are presented in which advantages as a hybrid database supporting XML in RDB are fully incorporated. Further, needs and the pros and cons of implementing XML data validation functionality using XML schema definitions (W3C XML Schema) are discussed and suggestions are given towards the future extension of XML functionalities in PostgreSQL.

Time

12:05 - 13:05 (60 minutes)

Abstract

To work database systems effectively, we are required various tuning techniques. This tutorial presents tuning technique for configuration parameters. Beginning with important ideas leading tuning process, we will choose important parameters from more than 100 parameters of PostgreSQL and present how to set the value to the parameters based on the knowledges about PostgreSQL internal behavior.

The audience can understand our topics easily when they have background about database administration (including design, configuration and operation of databases).

Profile

Tatsuhito Kasahara

He is working for NTT Open Source Software Center where he is in charge of technical support for PostgreSQL and develops some tools involved in PostgreSQL. He has joined PostgreSQL Mechanism Research Working Group since 2004.

Now, he joins PostgreSQL Documentation Group as a volunteer. And he is also member of JPUG's portal site 'Let's Postgres'.

Tetsuo Sakata

He entered Nippon Telegraph and Telephone Corp., in 1990.

Since then he has engaged himself in research and development of database system technology like as database design and multimedia databases. He started to work with PostgreSQL around 2003.

Since 2006 He has worked for NTT Open Source Software Center where he has engaged himself in spreading PostgreSQL in NTT in-house systems and managing PostgreSQL development.

On the other hand, he has become a member of Japan PostgreSQL User Group (JPUG) since 2003, and a director who is the chairperson of PostgreSQL Mechanism Research Working Group since 2004.

After 2008, he is also an operating member of JPUG's portal site 'Let's Postgres'.

Jun Kuwamura

Around 1995, he started to use Linux and PostgreSQL and participated the Linux Japanese FAQ(JF) project where he worked on the translation of FAQ of PostgreSQL and the standby package of Web+DB (LAPP) offered by Plamo Linux (a Japanese Localization of Linux) project. In the PostgreSQL project, he helped work arrangement of the contrib directory and debugged the authentication module in an early age.

He also participated writing or translating the several books concerning Kerberos authentication system, PHP language, and PostgreSQL. He is one of the founder of Japan PostgreSQL User Group (JPUG) and is a JPUG director who are in charge of PostgreSQL Mechanism Research Working Group.

Time

13:20 - 14:10 (50 minutes)

Abstract

I will solve SQL problems which I often look at in Oracle community. I will introduce SQL which emulated "window function" of Oracle10g and DB2 V9.5. I will explain my method of thinking SQL and my brain image of SQL. In this session,I will use simple SQL samples.

Summary page

Profile

One of Oracle ACE. Owner of OracleSQLPuzzle.

• OracleSQLPuzzle
• Aketi Jyuuzou's blog

Time

14:20 - 15:10 (50 minutes)

Abstract

This talk will focus on the technical problem and solution of the supporting Windows of PostgreSQL. In the past, SRA OSS,Inc. developed an original Windows version (this was named "PowerGres") of PostgreSQL 7.3 and 7.4, and have provided the result for the development community.

At present, we are developing some patches for 64bit native Windows Support for PostgreSQL 8.5.

Profile

Tsutomu Yamada started his carrier at SRA, Inc., in charge of Linux Open Source software, in specific, gdb and gcc for the several microchips.

Today, he set himself to the development 64-bit Windows version of PostgreSQL/PowerGres at SRA OSS, Inc. Japan.

Time

15:20 - 16:10 (50 minutes)

Abstract

User groups are the lifeblood of open source projects. They help us stay physically connected in a world that has become focused on outsourcing and virtualization. They spark creativity, help form personal relationships and are a way for PostgreSQL in particular to reach beyond our mailing lists and source repositories out into the greater world.

Japan PostgreSQL Users Group (JPUG) is the largest user group in the world. The success of this group is a model for open source user groups in Japan. In other parts of the world, there are a few well-established groups, and a large number of groups just getting started. This talk will discuss some of the differences in organization and culture of user groups in different parts of the world, provide status updates on projects from each and share best practices.

Profile

Magnus Hagander

Magnus Hagander is one of the developers at PostgreSQL Global Development Group. He is a core personel for implimentation and maintenance of PostgeSQL for Windows. He is also working on the development of PostgreSQL backend. Recently, Magnus was involved in authentication, SSL, and Kerberos related development.

Selena Deckelman

Selena Deckelmann works for End Point Corporation from her home in Portland, OR, where she is a PostgreSQL and Perl consultant. She is part of a volunteer group based in Portland that is reviving structured performance testing for PostgreSQL. The group is made up of students, professors and professionals in the area, all interested in database technology.

She is the User Group Liaison for the PostgreSQL Global Development Group. She currently leads PDXPUG, a PostgreSQL Users Group, and has helped start a programming group, Code-n-Splode, whose goal is to get more women involved in open source. She is also program chair of a grass-roots open source conference, Open Source Bridge (www.opensourcebridge.org). In her spare time, she collects eggs from her chickens, gardens and occasionally mixes drinks for her local Perl Mongers group.