DAY1

Time table


December 11, 2018
Track A (with translation) Track B
9:20 – 10:00 Reception
10:00 – 10:05 (5 min) Opening Speech
10:05 – 10:55 (50 min) KEYNOTE SPEECH:What is the Future of PostgreSQL?
Robert Haas / EnterpriseDB
10:55 – 11:00 (5 min) SPONSOR SHORT SESSION
SRA OSS, Inc. Japan
11:00 – 11:50 (50 min) KEYNOTE SPEECH:PostgreSQL and its ecosystems in China and North America
Grant Zhou / Highgo
11:50 – 13:00 (70 min) Lunch Break
13:00 – 13:40 (40 min) PostgreSQL replication in 2018
Magnus Hagander / Redpill Linpro
Minimize Downtime!
PostgreSQL Major Version Upgrade
Using built-in Logical Replication

Atsushi Torikoshi / NTT OSS Center
13:40 – 13:50 (10 min) Break
13:50 – 14:30 (40 min) Partitioning Shines in Postgres 11
Amit Langote / NTT OSS Center
Develop, migrate and test the large scale stored procedures
Haruka Takatsuka / SRA OSS, Inc. Japan
14:30 – 14:40 (10 min) Break
14:40 – 15:20 (40 min) Getting a feature committed
Michael Paquier / VMware
Bloat and Fragmentation in PostgreSQL
Masahiko Sawada / NTT OSS Center
15:20 – 15:30 (10 min) Break
15:30 – 16:10 (40 min) Database architecture for SaaS scale
Arul Shaji / Atlassian
Celebrating its 15th Anniversary:
Pgpool-II Past, Present and Future

Bo Peng / SRA OSS, Inc. Japan
Tatsuo Ishii / SRA OSS, Inc. Japan
16:10 – 16:20 (10 min) Break
16:20 – 17:00 (40 min) Five data models for sharding and which is right
Craig Kerstiens / Citus Cloud
Full throttle of the heterogeneous hardware
for big-data processing
– challenges towards 10GB/s of
query execution performance

Kohei Kaigai / HeteroDB

 
 
 

Agenda


What is the Future of PostgreSQL?

12/11 10:05 – 10:55

– Abstract –

Over the last several years, PostgreSQL has added multiple ground-breaking capabilities, including parallel query, logical replication, declarative partitioning, and just-in-time compilation. In this talk, I’ll discuss how I expect to see these capabilities evolve in future releases, as well as some new capabilities that may be coming to PostgreSQL in the next few years.

– Speaker –

Robert_Haas
Robert Haas / EnterpriseDB

Robert Haas is a PostgreSQL major contributor and committer. PostgreSQL features which he has authored or coauthored include unlogged tables, fast-path locking, index-only scans, and parallel query. PostgreSQL features written by others which he has reviewed and committed include partitioning, logical decoding, event triggers, and foreign tables. He works at EnterpriseDB as VP, Chief Database Architect.

Presentation: English(with translation)
Material: English

PostgreSQL and its ecosystems in China and North America

12/11 11:00 – 11:50

– Abstract –

I will give the Japan Community an overview of the PostgreSQL ecosystems in China and North America, and introduce the COPU, China PostgreSQL Association organizations to the community for the connections between Japan and China. In addition, I will introduce the PostgreSQL technical practices and trends in China. China PostgreSQL Association welcomes Japan PostgreSQL contributors, corporations to extend their influences to China and the Association will be a bridge for the international connections on PostgreSQL industry.

– Speaker –

Grant_Zhou
Grant Zhou / Highgo

Grant currently lived in Canada and worked as the General Manager of Highgo Software USA Corp, which is a R&D branch of Highgo Software. He worked in Alcatel-Lucent (Nokia) company for more than ten years and have rich experiences on high availability and real-time telecommunication systems. He is working as the director of China PostgreSQL Association, and the secretary of the International Consultant Committee of the association the same time.

Presentation: English(with translation)
Material: English

PostgreSQL replication in 2018

12/11 13:00 – 13:40 @ Track A

– Abstract –

The world of PostgreSQL replication has come a long way from the days of manually compiling and installing erServer. The options are new, and there are many of them, directed at solving different problems. This talk takes a look at some of the options available today and tomorrow.

– Speaker –

Magnus_Hagander
Magnus Hagander / Redpill Linpro

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.

Presentation: English(with translation)
Material: English

Minimize Downtime! PostgreSQL Major Version Upgrade Using built-in Logical Replication

12/11 13:00 – 13:40 @ Track B

– Abstract –

PostgreSQL major version upgrade needs to stop database service for a quite long time, especially on large databases. Some people expect using Logical Replication will shorten the downtime dramatically. However, through our challenge of minimizing downtime during migration, we faced many hurdles mainly due to the behavior of Logical Replication. In this session, I will go through some basics of Logical Replication feature that was added in PostgreSQL 10 and based on it, explain some major problems which we encountered when applying Logical Replication to online major version upgrade and introduce workarounds that we used.

– Speaker –

Atsushi_Torikoshi
Atsushi Torikoshi / NTT OSS Center

Since 2007 he has engaged in business related to open source software.
From 2016 NTT OSS Center is providing technical support around PostgreSQL.

Presentation: Japanese
Material: English

Presentation material


Partitioning Shines in Postgres 11

12/11 13:50 – 14:30 @ Track A

– Abstract –

Postgres 10, which was released last fall, introduced native table partitioning. Over the year since initial release, significant amount of work has gone into adding numerous user-level partitioning features and enhancing the performance. In this talk, I will introduce the features newly introduced in Postgres 11, after going over the basics of declarative partitioning. I will also describe the performance improvements and provide a peek into the future scalability work.

– Speaker –

Amit_Langote
Amit Langote / NTT OSS Center

Amit is a software developer with NTT Open Source Software Center since 2013 and has been working with PostgreSQL since around the same time.
He has contributed to prominent features like table partitioning, command progress reporting in recent PostgreSQL releases.

Presentation: English(with translation)
Material: English

Presentation material


Develop, migrate and test the large scale stored procedures

12/11 13:50 – 14:30 @ Track B

– Abstract –

This talk will explain points of developing a large systemthat uses a great many user defined functions and stored procedures.It will also mention migrating such a system from proprietary DBMS.

– Speaker –

Haruka_Takatsuka
Haruka Takatsuka / SRA OSS, Inc. Japan

Haruka Takatsuka was involved in the Japan PostgreSQL User Group as a volunteer staff member from 2005.
He is a director since 2006, and now he is a president from 2016.
He belongs to SRA OSS, Inc. Japan and he has engaged in PostgreSQL related work as training lecturer, support staff, technical consultant and so on in recent years.
He has written a book “Shin-Hyoujun PostgreSQL” (Softbank Creative).

Presentation: Japanese
Material: Japanese

Getting a feature committed

12/11 14:40 – 15:20 @ Track A

– Abstract –

PostgreSQL is unique in its way of handling incoming patches and feature proposals with its commit fest system, and getting a feature accepted or rejected can be hard to accept for newcomers which perhaps do not have a lot of insight about how the community works.

– Speaker –

Michael_Paquier
Michael Paquier / VMware

Michael Paquier is a PostgreSQL major contributor and committer.
He has contributed to many features, reviews and bug fixes over the years, with many areas touched among which are authentication, backup, WAL, Windows and the testing framework.
He works at VMware as Senior Member of Technical Staff.

Presentation: English / Japanese(with translation)
Material: English

Bloat and Fragmentation in PostgreSQL

12/11 14:40 – 15:20 @ Track B

– Abstract –

Database bloat and database fragmentation are well-known issues and are often the cause of a lot of problems such as performance degradation. Why do those problems occur in PostgreSQL? And how can we deal with them properly in recent PostgreSQL? In this talk, I’ll deep dive into database bloat and fragmentation in terms of both the PostgreSQL internal and DBA aspects.

– Speaker –

Masahiko_Sawada
Masahiko Sawada / NTT OSS Center

Masahiko Sawada has worked on developing and support service of PostgreSQL at NTT OSS since 2016.
In PostgreSQL development community, he is working on replication, vacuuming and other.

Presentation: English and Japanese
Material: Japanese

Database architecture for SaaS scale

12/11 15:30 – 16:10 @ Track A

– Abstract –

We are in the middle of what is called a Cambrian SaaS wave. Majority of these SaaS offerings are underpinned by accumulation of massive amounts of data, efficient storage of that data and agile, secure utilisation of that data, to form the basis of innovation. There is quite a number of factors to be considered before one can decide on the choice of database, infrastructure and architecture. In this talk, I will give an insight into this process and show why PostgreSQL is quickly becoming the RDBMS of choice for many of these SaaS offerings and how PostgreSQL database infrastructure is architected for such SaaS offerings.

– Speaker –

Arul_Shaji

Arul Shaji / Atlassian

Arul Shaji is a Principal Database Consultant at Atlassian.
He is part of the team that builds and operates the database platform in the cloud for Atlassian’s popular products such as JIRA and Confluence, using relational, NoSQL and BigData technologies.
In his previous roles, Arul has implemented enterprise scale database platforms for major banks, telecom and cards payments sectors.
His major area of interest is in building reliable, fault tolerant and scalable data platforms in the cloud to handle massive scale data.
Arul has been working with PostgreSQL for more than a decade and was an active PostgreSQL hacker, having contributed features such as Updateable Cursors and CSV Logging.

Presentation: English(with translation)
Material: English

Celebrating its 15th Anniversary: Pgpool-II Past, Present and Future

12/11 15:30 – 16:10 @ Track B

– Abstract –

It’s 15th anniversary for Pgpool-II in this year since the first release.This talk will look back on Pgpool-II’s history, and introduce its new features.

– Speakers –

Bo_Peng
Bo Peng / SRA OSS, Inc. Japan

Bo Peng works for SRA OSS, Inc. Japan.
She is in charge of open source software support, construction work and is also a developer of Pgpool-II.
In Pgpool-II project, besides working on new features and bug fixes, she is responsbile for release management and document management.

Tatsuo_Ishii
Tatsuo Ishii / SRA OSS, Inc. Japan

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.
He is working for SRA OSS, Inc. Japan as a branch manager.

Presentation: Japanese
Material: English

Five data models for sharding and which is right

12/11 16:20 – 17:00 @ Track A

– Abstract –

Whether you’re working with a single node database, a distributed system, or an MPP database, a key factor in the flexibility you get with the system is how you shard or partition your data. Do you do it by customer, time, or some random uuid? Here we’ll walk through five different approaches to sharding your data and when you should consider each. If you’re thinking you need to scale beyond a single node this will give you the start of your roadmap for doing so. We’ll cover the basics of how you can do this directly in Postgres as well as principles that apply generically to any database.

– Speaker –

Craig_Kerstiens
Craig Kerstiens / Citus Cloud

Craig runs Citus Cloud, a database as a service focused on scaling Postgres out horizontally.
Prior to Citus Craig ran Heroku Postgres.
He curates Postgres Weekly.

Presentation: English(with translation)
Material: English

Presentation material


Full throttle of the heterogeneous hardware for big-data processing
– challenges towards 10GB/s of query execution performance

12/11 16:20 – 17:00 @ Track B

– Abstract –

This session introduce our approach (and trial-and-errors under the development) to achieve 10GB/s query execution throughput for terabytes-class data on single-node, by the extreme utilization of GPU and NVME-SSD.

– Speaker –

Kohei_Kaigai
Kohei Kaigai / HeteroDB

Kaigai Kohei is a primary developer of PG-Strom, and has been contributed various features of PostgreSQL for over ten years.
He is especially interested in heterogeneous-architecture of database system, and in-database machine-learning / statistical analysis.
Nowadays, he is co-founder of HeteroDB,Inc, works for development of both technologies and businesses.

Presentation: Japanese
Material: English and Japanese