September 23, 2016

DAY 1

December 2, 2016 – Business Day (DAY 1)
track A (translated) track B
10:00 – 10:10 (10 min) Opening speech
10:10 – 10:55 (45 min) A History of the PostgreSQL Project
Peter van Hardenberg
Salesforce.com
keynote
10:55 – 11:40 (45 min) PostgreSQL Story in China, in Alibaba Cloud(Aliyun)
Scott Siu
Alibaba Cloud
keynote
11:40 – 13:00 (80 min) Lunch break
13:00 – 13:45 (45 min) What’s New in 9.6, by PostgreSQL contributor
Masahiko Sawada
NTT OSS Center
Hacking
Hitachi’s efforts to apply PostgreSQL to mission critical systems
Tsuyoshi Inagaki
Hitachi
Case study
13:45 – 14:00 (15 min) Break
14:00 – 14:45 (45 min) Parallel Query In PostgreSQL!
Amit Kapila
Enterprise DB
Hacking
Why PostgreSQL ?
Story of Fujitsu’s footprints with PostgreSQL

Yamamoto Akinori / Higuchi Daisuke
Fujitsu
Case study
14:45 – 15:15 (30 min) Coffee break
15:15 – 16:00 (45 min) Using PostgreSQL in Tantan
– From 0 to 350bn rows in 2 years

Victor Blomqvist
Tantan
Case study
PL/CUDA – The fusion of HPC grade computing power with in-database analytics
Kaigai Kohei
NEC
Hacking
16:00 – 16:15 (15 min) Break
16:15 – 17:00 (45 min) Case Study: Application of PostgreSQL
to the large social infrastructure

Kunio Tanji / Ayumi Ishii
The Chugoku Electric Power Co / Inc., NTT Data
Case study
Migrations to PostgreSQL
Venkata B N
Sr. PostgreSQL Consultant
Migration

A History of the PostgreSQL Project

December 2, 10:10 – 10:55

Abstract
The history of the PostgreSQL project dates back more than 25 years. In this talk, we’ll look back on both the human and the technical history of the project and hear from project contributors throughout the project’s
history in their own words. How did they join the project? What are they doing today? Attending this talk should leave you with a deeper understanding of why Postgres has succeeded over a long period and how it came to be the project that it is today.

peter_van_hardenberg
Speaker
Peter van Hardenberg
Salesforce.com, Canada
pvh@pvh.ca

Profile
Peter van Hardenberg was the founding member of the Heroku Postgres team which exists to make databases accessible to application developers at any scale. He’s built products, systems, and teams during his career which has ranged from collecting research data offshore in the Arctic Ocean, writing physics engines for games on Nintendo’s 3DS console, and building developer experiences at Heroku.

Language of presentation: English
Language of presentation material: English


PostgreSQL Story in China, in Alibaba Cloud(Aliyun)

December 2, 10:55 – 11:40

Abstract
Since 2011 years, China Postgres User Group hosting a national technology conference in China every year, this past October, is the 7th.
In June 2015, Aliyun released ApsaraDB for RDS (PostgreSQL) database services, currently we have support 3 database engines including PostgreSQL, PPAS and Greenplum. In addition to providing a cloud platform based on RDS, we also send “dbsync” in GitHub as a open source project, to help users replicate data from MySQL to PostgreSQL/Greenplum.
By this time on the 20th anniversary of the PostgreSQL, hope that through the story happened in my side, let everybody know China PostgreSQL community, and let us do more fusion around the world.

scot_siu
Speaker
Scott Siu
Alibaba Cloud Company (Aliyun.com), China
shaocong.xsc@alibaba-inc.com

Profile
Scott Siu is the Core Team member and the Founder of the PostgreSQL China User Group.
Scott has been in Alibaba Cloud (Aliyun.com) in 2015 and currently leading Postgres product team as Product Director (include PostgreSQL, PPAS, Greenplum engines).

Language of presentation: English
Language of presentation material: English


What’s New in 9.6, by PostgreSQL contributor

December 2, 13:00 – 13:45 @ Track A
masahiko_sawada
Abstract
PostgreSQL contributor explains detail of PostgreSQL 9.6 new features including inside story.

Speaker
Masahiko Sawada
NTT OSS Center
sawada.mshk@gmail.com
Twitter
LinkedIn

Profile
Mr. Sawada works for NTT open source software center. He has been working on software development and technical support for PostgreSQL as a database engineer since he joined the company. As for PostgreSQL 9.6, he has developed Freeze Map and multi-synchronous replication. Currently, he is working on enhancement of FDW and replication function.

Language of presentation: Japanese
Language of presentation material: English


Hitachi’s efforts to apply PostgreSQL to mission critical systems

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

Abstract
Hitachi has responded to the needs of customers by developing mainframes and databases in order to satisfy the requirements of mission critical systems.
In this session, we will introduce Hitachi’s efforts to fill the gap between the requirements for mission critical systems and functionality provided by PostgreSQL.

t_inagaki

Speaker
Tsuyoshi Inagaki
Hitachi
tsuyoshi.inagaki.ej@hitachi.com

Profile
Tsuyoshi Inagaki works at OSS Solution Center, Hitachi, Ltd. He is promoting the use of OSS for business, and currently in charge of supporting projects using OSS DBs including PostgreSQL, MySQL and MongoDB. He joined the PostgreSQL Enterprise Consortium in 2013 and has been working on studying, doing verifications and advocating PostgreSQL to promote it to enterprise business.

Language of presentation: Japanese
Language of the talk material: Japanese or English


Parallel Query In PostgreSQL!

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

amit_kapila

Abstract
In this talk, I will discuss all the parallel query features users can use with 9.6 and what is in pipeline for 10.0 and future versions.

Further, I will discuss the specifics of Parallel Sequential Scans and Parallel Joins with a focus on cases where they can help users and where they cannot. It will also describe the user tunable knobs for parallel query and the work done in optimizer to choose parallel plans.

Finally, I will share some of TPC-H queries where the benefit of parallel query can be seen.

Speaker
Amit Kapila
Enterprise DB
amit.kapila16@gmail.com


Profile
Amit Kapila is a Senior Database Architect in EnterpriseDB and is working with both open source PostgreSQL and EDB’s Postgres Plus Advanced Server. Over the course of a 16-year career, he developed deep expertise in not only PostgreSQL but also Oracle, and specific technology areas such as in-house in-memory databases. Amit Kapila participates actively in the development of PostgreSQL,both developing and reviewing new features. In the past, he has worked on integrating in-memory storage Engine, he integrated the Redo-Replication solution to PostgreSQL-based code and at a time he also improved the Oracle performance by doing statement caching.

Language of presentation: English
Language of the talk material: English


Why PostgreSQL ?
Story of Fujitsu’s footprints with PostgreSQL

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

Abstract
Now there are many choices of database include proprietary database or open source database, we need to find the right database in the right place.
Fujitsu have strategically picked PostgreSQL as its chosen database platform and create innovation with customers.
This talk will shared Fujitsu’s direction and some insights on PostgreSQL offerings.
The talk will have the following major sections:
– The reasons why Fujitsu chose PostgreSQL
– Key factors which are needed in the enterprise use
– Fujitsu’s engagement with PostgreSQL community

yamamoto
Speaker 1
Yamamoto Akinori
Fujitsu
akinori@jp.fujitsu.com

Profile
Akinori has been involved with PostgreSQL since 2006 and engaged in the development of PostgreSQL products. He is a technical lead to group of pre-sales. He works on many mission critical projects and leads to success the projects. Akinori is major contributor of PGECons, his expertise is mission critical technologies for enterprise ICT system.


higuchi
Speaker 2
Higuchi Daisuke
Fujitsu
higuchi.daisuke@jp.fujitsu.com

Profile
Daisuke joined Fujitsu Ltd. in 2014. He is working with Fujitsu’s database products ‘FUJITSU Enterprise Postgres’ and ‘Symfoware Server’. He develops deep expertise in specific technology areas such as data encryption, SQL pre-processor for COBOL program. He participates actively in the PostgreSQL community as well.

Language of presentation: Japanese
Language of the talk material: Japanese


Using PostgreSQL in Tantan – From 0 to 350bn rows in 2 years

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

Abstract
Tantan is at the moment the best location based dating app for Android and iOS in China and hopefully soon in all of East Asia. We started early summer 2014 on a blank sheet and now store more than 350 billion rows in PostgreSQL. Our 4 million daily users generate about 500k database requests per second during peak, distributed over 150 servers.

In this talk I will cover how PostgresSQL together with PostGIS forms the backbone of Tantan; the workload we have, the hardware we use, the software we use and also challenges we meet and a quick look at our custom sharding solution. In previous talks I have given about how we use PostgrsSQL in Tantan people have asked for a more broad view and this is what I hope to give in this talk.

victorblomqvist

Speaker
Victor Blomqvist
Tantan
China
blomqvist@p1.com

Profile
Victor is currently lead of data & algorithms at the dating company Tantan where he has handled all parts from development in Go to database management of PostgreSQL. He was part of the original development team and has first-hand experience facing the tremendous growth and challenges Tantan has encountered along the way.

Language of presentation: English
Language of the talk material: English


PL/CUDA – The fusion of HPC grade computing power with in-database analytics

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

Abstract
This session introduces a new approach to run advanced analytic workloads on database systems. PL/CUDA allows to write up highly calculation intensive workloads as SQL functions, and execute them on GPU device which have thousands processor cores. We also introduced a case of similarity search on drug-discovery area and its success by PL/CUDA.

kaigai_profile

Speaker
KaiGai Kohei
NEC, Japan
kaigai@ak.jp.nec.com

Profile
KaiGai Kohei has about 10 years experiences for PostgreSQL core development, and contributed various features on security, FDW, pluggable planner/executor and so on.
He also launched PG-Strom project 4 years before, to optimize the database workloads using the latest heterogeneous computing approach.
Nowadays, he leads both of this open source project and the in-company startup project to leverage this technology.

Language of presentation: Japanese
Language of the talk material: Japanese and English


Case Study: Application of PostgreSQL to the large social infrastructure

December 2, 16:15 – 17:00 @ Track A

Abstract
The Chugoku Electric Power Co.,Inc and NTT Data Corporation successfully applied PostgreSQL to the Meter Data Management System known as a large social infrastructure.In this session, I will talk about the case study of this system.
tanji_kunio
Speaker 1
Kunio Tanji
The Chugoku Electric Power Co.,Inc

Profile
Mr. Tanji joined The Chugoku Electric Power Co.,Inc in April 1981. He experienced Power Distribution Division, Sales Headquarters, and Energia Division, and finally he was assigned to the Information and Communication Division (information system). From June 2010, he started to manage information system related business as a Director of Information and Communication Division (information system). From June 2013, he took office as Corporate Executive Officer / Director of Information and Communication Division (information system).


ishii_ayumi
Speaker 2
Ayumi Ishii
NTT DATA
ishiiaym@nttdata.co.jp

Profile
Ms. Ishii joined NTT DATA Corporation in 2014. She expected to work for OSS-DB area that she was interested in from when she was a student, and she was assigned to PostgreSQL team. From then, she started to work for research and development, and technical support of PostgreSQL.


Language of presentation: Japanese
Language of the talk material: Japanese and English


Migrations to PostgreSQL

December 2, 16:15 – 17:00 @ Track B

Abstract
Real-time Migration challenges encountered when migrating Databases/Applications from Enterprise Database like Oracle/SQL Server to PostgreSQL.

venkata_b_n

Speaker
Venkata B N
Sr. PostgreSQL Consultant
nag1010@gmail.com

Profile
Sr. Database Consultant with 10+ years of experience and currently working as Sr. PostgreSQL Consultant.


Language of presentation: English
Language of the Talk Material: English


* The program has been changed.