DAY1

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 –

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 –

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 –

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 –

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 –

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 –

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 –

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 –

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 –

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 –

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 –

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 –