September 23, 2016

DAY 2

December 3, 2016 – Community Day (DAY 2)
track A (translated) track B
10:00 – 10:45 (45 min) YeSQL: Battling the NoSQL Hype Cycle with Postgres
Bruce Momjian
Enterprise DB
Lecture
PGXZ:
Large-Scale Distributed DBMS
(Application to Mobile Payment System)

Xu Zhongqing
Tencent
Case study
10:45 – 11:00 (15 min) Break
11:00 – 11:45 (45 min) PostgreSQL Backups the modern way
Magnus Hagander
Redpill Linpro
Admin
Beyond EXPLAIN: Query Optimization Behind the Scenes
Yuto Hayamizu
The University of Tokyo
Lecture
11:45 – 13:00 (75 min) Lunch break
13:00 – 13:45 (45 min) Performance Improvements in PostgreSQL 9.5, 9.6 and beyond
Tomas Vondra
2ndQuadrant
Hacking
Pgpool-II: Past, Present and Future
Tatsuo Ishii / Yugo Nagata
SRA OSS
clustering
13:45 – 14:00 (15 min) Break
14:00 – 14:45 (45 min) PGroonga
– Make PostgreSQL fast full text search platform for all languages!

Kouhei Sutou
ClearCode Inc.
Hacking
Logical Replication, Sharding & Multimaster Clusters
Simon Riggs
2ndQuadrant
Clustering
14:45 – 15:15 (30 min) Coffee break
15:15 – 16:00 (45 min) Evolution of pgAdmin: pgAdmin4
Dave Page
Enterprise DB
Admin
What are the similarities and differences of using PostgreSQL between Japan and Europe?
Yoko Takase
Ashisuto
Case study
16:00 – 16:15 (15 min) break
16:15 – 17:00 (45 min) LT & Closing speech

YeSQL: Battling the NoSQL Hype Cycle with Postgres

December 3, 10:00 – 10:45 @ Track A

Abstract
Relational databases are regularly challenged by new technologies that promise to make SQL obsolete, but the new technologies often fade into obscurity. This talk explores how new NoSQL technologies are unique, and how existing relational database systems like Postgres are adapting to handle NoSQL workloads.

bruce
Speaker
Bruce Momjian
Enterprise DB
bruce@momjian.us

Profile
Bruce Momjian is co-founder and core team member of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He has been employed by EnterpriseDB since 2006. He has spoken at many international open-source conferences and is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world’s largest law firms. As an academic, Bruce holds a Masters in Education, was a high school computer science teacher, and lectures internationally at universities.

Language spoken during the talk: English
Language of the talk material: English


PGXZ:Large-Scale Distributed DBMS (Application to Mobile Payment System)

December 3, 10:00 – 10:45 @ Track B

Abstract
PGXZ, based on open source PostgreSQL-XC, is a distributed database system developed by Tencent. The biggest PGXZ cluster, with 60 datanodes, is using on WeChat Payment System which supplies one of the biggest mobile payment service in China. Data volume in PGXZ cluster is over 25TB until now and is growing very fast. The new data volume of per month is about 1.5 times as that of last month. PGXZ cluster used in WeChat Payment System has up to 20,000 tps and 8,000 qps.

xu_zhongqing
Speaker
Xu Zhongqing
Tencent, China
yorkxu@tencent.com

Profile
After taking an Master Degree in Computer Science from Huazhong University of Science and Technology in 2007, I had been working for Huawei until the end of 2014. And now, I am working for Tencent, one of the biggest Internet companies in China, and responsible for architecture design and development about PGXZ, a distributed database cluster derived from PGXC.

Language spoken during the talk: English
Language of the talk material: English


PostgreSQL Backups the modern way

December 3, 11:00 – 11:45 @ Track A

Abstract
There have been many different ways to take backups of PostgreSQL systems over the years, and the tools to do so have evolved both inside PostgreSQL and as addons. Are you using pg_dump for backups? Calling pg_start_backup()? Writing an archive_command? Then you’re probably missing out on new features, and possibly even risking your backups. In this talk we’ll go through the “right” way to do backups on modern versions of PostgreSQL, both using builtin tools and proven external utilities.

magnus_hagander

Speaker
Magnus Hagander
Redpill Linpro, Sweden
magnus@hagander.net

Profile
Magnus Hagander is a member of the PostgreSQL Core Team and a developer and code committer in the PostgreSQL Global Development Group. Magnus is one of the original developers of the Windows port of PostgreSQL. These days, he mostly works on other parts of the PostgreSQL backend, recently with a focus on security features, monitoring and backup/replication interfaces and tools. He is also one of the core members of the postgresql.org infrastructure team, maintaining the servers that power the project, and one of the maintainers of the postgresql.org website. He also contributes to pgAdmin and other related projects. He’s been a PostgreSQL user since version 6 (with some non-serious use of Postgres 95 before that), and currently serves on the Core Team and as President of the Board for PostgreSQL Europe. To pay the bills, he is a PostgreSQL and open source software consultant at Redpill Linpro in Stockholm, Sweden, where he works on consulting, support and training services, as well as custom development work.

Language spoken during the talk: English
Language of the talk material: English


Beyond EXPLAIN: Query Optimization Behind the Scenes

December 3, 11:00 – 11:45 @ Track B

Abstract
EXPLAIN is too much explained. Let’s go “beyond EXPLAIN”.
This talk will take you to an optimizer backstage tour: from theoretical background of state-of-the-art query optimization to close look at current implementation of PostgreSQL. Experiences to hack the optimizer in our laboratory will also be shared.

yuto_hayamizu

Speaker
Yuto Hayamizu
The University of Tokyo, Japan
haya@tkl.iis.u-tokyo.ac.jp
Twitter

Profile
Yuto Hayamizu is a hardcore database researcher, and also known as performance measurement gru in the Japanese PostgreSQL community. He enjoys hacking PostgreSQL in his research activity and speaking about PostgreSQL at various events such as PGCon and JPUG meetups. He received JPUG Thanks Award 2013 for his outstanding contribution to Japanese PostgreSQL community.

Language spoken during the talk: English
Language of the talk material: English


Performance Improvements in PostgreSQL 9.5, 9.6 and beyond

December 3, 13:00 – 13:45 @ Track A

Abstract
Recent PostgreSQL releases bring plenty of new features, and a lot of them are related to performance – PostgreSQL 9.5 and 9.6 are not an exception – parallel queries, multiple improvements of sorting
performance, hashjoin improvements, lock scalability, optimizer improvements, etc. This talk aims to present the main performance improvements along with benchmarks illustrating the gains.

I also plan to briefly talk about what may happen in the near future – what performance-related features the community are in the works.

tomas_vondra

Speaker
Tomas Vondra
2ndQuadrant, Czech
tomas.vondra@2ndquadrant.com

Profile
Tomas first met PostgreSQL in 2003 and quickly became a big fan. He participated in porting various applications to PostgreSQL from other databases, tuning and fixing performance issues etc. He is also a member of the executive committee of CSPUG (Czech and Slovak PostgreSQL Users Group), an “umbrella” organization for the local PostgreSQL community. Tomas currently works as a database engineer 2ndQuadrant, working on various PostgreSQL-related tasks.

Language spoken during the talk: English
Language of the talk material: English


Pgpool-II: Past, Present and Future

December 3, 13:00 – 13:45 @ Track B

Abstract
Pgpool-II now has 13 years of history if counted from the first generation of the software, pgpool.
Pgpool was originally born aiming to add missing features to PostgreSQL, including connection pooling and replication.
It has been evolving to Pgpool-II with a growth of PostgreSQL, and now it is used by many users in all over the world.

In this talk we first present the history of evolution of Pgpool-II,
then explain available features of Pgpool-II and how we can use them in a production environment.

Finally we will give some ideas for the future of Pgpool-II.

100902_02

Speaker1
Tatsuo Ishii
SRA OSS, Inc. Japan
ishii@sraoss.co.jp

Profile
Tatsuo Ishii is the original author of the earliest version of Pgpool-II. Currently, he is actively working on development of Pgpool-II as a project leader.
He has been involved in PostgreSQL since it was born and is one of the PostgreSQL committers.
His is working for SRA OSS, Inc. Japan as a branch manager.

nagata_yugo

Speaker2
Yugo Nagata
SRA OSS, Inc. Japan
nagata@sraoss.co.jp

Profile
Yugo Nagata is a member of PostgreSQL professional technical group in SRA OSS, Inc. Japan.
He is in charge of PostgreSQL support, training and consulting, and also is a developer of Pgpool-II.

Language spoken during the talk: Japanese
Language of the talk material: Japanese and English


PGroonga – Make PostgreSQL fast full text search platform for all languages!

December 3, 14:00 – 14:45 @ Track A

Abstract
PostgreSQL has built-in full text search feature. But it supports only limited languages. For example, it doesn’t
support Japanese. pg_trgm bundled in PostgreSQL supports all languages including Japanese. But it has performance problems for large documents.

This talk describes about PGroonga that resolves these problems.
kouhei_sutou
Speaker
Kouhei Sutou
ClearCode Inc.
kou@clear-code.com
Twitter
LinkedIn

Profile
He is the author of PGroonga. He fixed some PostgreSQL bugs he found while he develops PGroonga.

Language spoke during the talk: Japanese
Language of the Talk Material: Japanese and English


Logical Replication, Sharding & Multimaster Clusters

December 3, 14:00 – 14:45 @ Track B

Abstract
Review of progress on PostgreSQL technologies for logical replication using both pglogical and in-core replication, as well as their use for multi-master clustering in the Postgres-BDR project. We will also discuss Postgres-XL and other technologies.

simon_riggs

Speaker
Simon Riggs
2ndQuadrant, England
simon@2ndquadrant.com

Profile
Simon Riggs is a PostgreSQL Committer and CTO of 2ndQuadrant, the Open Source PostgreSQL Support Company.

Language spoke during the talk: English
Language of the Talk Material: English


Evolution of pgAdmin: pgAdmin4

December 3, 15:15 – 16:00 @ Track A

Abstract
In this talk we’ll look at the evolution of the most popular Open Source management tool for PostgreSQL from pgAdmin III to the upcoming pgAdmin 4. We’ll look at the reasons for the re-write, technology choices, requirements, development methodology, and end with a demonstration of the new application.

dave_page
Speaker
Dave Page
Enterprise DB, England
dpage@pgadmin.org

Profile
Dave Page has been actively involved in the PostgreSQL Project since 1998,as the lead developer of pgAdmin, maintainer of the PostgreSQL installers and one of the projects resident Windows hackers. He also serves on the project’s web and sysadmin teams and is a member of the PostgreSQL Core Team. Dave is employed by EnterpriseDB where he works as Vice President & Chief Software Architect, Tools & Installers on EnterpriseDB products in addition to his community PostgreSQL work.

Language spoke during the talk: English
Language of the Talk Material: English


What are the similarities and differences of using PostgreSQL between Japan and Europe?

December 3, 15:15 – 16:00 @ Track B

Abstract
Open source software have been developed by a lot of developers all over the world and it is said that the number of developers working in Europe is the second largest part in the world, just after the US. Although PostgreSQL is one of the open source software born in the US, many useful features and tools have been appeared by European developers and introduced in every PostgreSQL event. Moreover the number of case studies that PostgreSQL is used on the large-scaled systems has also been increasing in Europe.

I have realized that there were the technical information which had not come into Asia and Japan yet, and similarities and differences of using PostgreSQL between Japan and Europe, through joining the events held in the UK, Spain, Belgium and Austria since I started to work in the UK in spring 2014. I hope my presentation introducing them will be helpful to those people who use PostgreSQL and consider using it.

YTakase
Speaker
Yoko Takase
Ashisuto, Japan
ykoizumi@ashisuto.co.jp

Profile
Yoko Takase took part in the starting up of PostgreSQL and EDB Postgres services in Ashisuto, after engaging in supporting of Oracle Database. She moved to the UK in April, 2014 and has been writing up how database things are in Europe.

Language spoke during the talk: English (Japanese is also OK)
Language of the Talk Material: English

* The program has been changed.