Postgres Conference

CHINA 2020 And PGConf.Asia 2020

In 2020, Both PostgresConf.CN and PGConf.Asia will host together, for the very first time, a joined online PostgreSQL conference with additional offline sessions hosted at several reputable University campus in China. It will be one of the biggest PostgreSQL conferences ever hosted in Asia.

This conference will be an Online conference together with several offline sites in several University campus in China.

PostgresConf.CN is an annual conference held by the China PostgreSQL Association for PostgreSQL users and developers. It is also one of the conference series held by PostgresConf Organization. PostgreConf.CN 2019 took place in Beijing, it was very well attended by PostgreSQL users and community members across the globe.

PGCONF.Asia is also an annual PostgreSQL event that took place in Bali Indonesia in 2019, it was a continuation of the PGCONF.Asia event that took place in Tokyo, Japan in 2018. The first PGCONG.Asia conference took place in 2016 in Tokyo, this conference acts as a hub of PostgreSQL related development and technical discussion among PostgreSQL users and developers in the region as well as experts from around the globe.

HOME

www.postgresconf.cn/en

www.pgconf.asia

Some of our speakers

Jim Mlodgenski

Amazon Web Services

Principle Database Engineer

Bruce Momjian

EDB

Vice President, Postgres Evangelist

David Steele

Crunchy Data Solutions

Senior Data Architect

Jignesh Shah

Amazon Web Services

Software Development Manager

Julyanto SUTANDANG

Equnix Business Solutions, PT

Ibrar Ahmed

pgEdge

Principal Engineer

Ahsan Hadi

pgEdge Inc

Director Support & Services

Peter Zaitsev

Percona

CEO

Muhammad Usama

HighGo

Database architect / PostgreSQL consultant

Cary Huang

Highgo Software

Software developer

Amit Kapila

Fujitsu

Senior Director

Hamid Akhtar

Percona

Engineering Lead - PostgreSQL

Andrey Lepikhov

Postgres Professional

Developer

Ashutosh Bapat

2ndQuadrant

PostgreSQL hacker

Yuya Watari

NTT

Researcher

Tatsuo Ishii

SRA OSS, Inc. Japan

Branch manager

Bo Peng

SRA OSS, Inc. Japan

Engineer

Yugo Nagata

SRA OSS, Inc. Japan

Chief Scientist

Lucky Haryadi

Equnix Business Solutions

Chief Technology Officer

Yandong Yao

yMatrix Inc.

Founder

Conference Highlights

Nov 19 Bruce Momjian

Will Postgres Live Forever?

This presentation explains how open source software can live for a very long time, and covers the differences between proprietary and open source software life cycles. It also covers the increased adoption of open source, and many of the ways that Postgres is innovating to continue to be relevant.

Nov 19 Tatsuo Ishii

Wonderful PostgreSQL!

In this talk I would like to introduce the history of PostgreSQL: before it was born, how it was born and how it has evolved, being supported by many great contributors. I think this talk will be interesting for especially young PostgreSQL users who do not know the history of PostgreSQL. This talk was first presented in 2017 in Japan for local PostgreSQL community. I will follow up the recent information to update the slide (and of course translate into English). If you are interested,...

Nov 19 Jim Mlodgenski

Top 10 Mistakes When Migrating From Oracle to PostgreSQL

As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just by not understanding how PostgreSQL is different than Oracle. In this talk, we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action.

Nov 19 Bruce Momjian

Postgres and the Artificial Intelligence Landscape

Artificial intelligence, machine learning, and deep learning are intertwined capabilities that attempt to solve problems that defy traditional computational solutions --- problems include fraud detection, voice recognition, and search result recommendations. While they defy simple computation, they are computationally expensive, involving computation of perhaps millions of probabilities and weights. While these computations can be done outside of the database, there are specific advantages of...

Nov 19 Yandong Yao

large scale time series database based on PostgreSQL for PB scale data

With the rapid growth of IoT and IIoT, time series data becomes the fastest growing data and bring new challenges to users. Existing technologies are either unable to handle PB scale data or are slow in terms of performance or devops. This topic will introduce a new time series database based on PostgreSQL which is linear scalable to handle PB+ data with great performance, fully ACID compliance and standard SQL.

Nov 19 Yuya Watari

Speeding Up Analytic Queries by Sharing Commonalities

Analyzing data plays an important role in business and fast query processing is the key. A method for significantly speeding up analytic queries will be presented in this talk that urges sharing of commonalities among queries. Analyzing large amounts of data that is generated in corporate business activities and feedbacking the results for the next action has gained importance. This type of analysis is referred to as Business Intelligence (BI). A type of UI to it, BI dashboards are widely...

Nov 19 Lucky Haryadi

Equnix Data Integration Management, an Automated High Performance ETL Tool for PostgreSQL

Doing migration or synchronize data from multiple data sources might be confusing and bothersome, especially from different RDBMS or data format. To managed such activity, ETL Process is the common mechanism and tool, but there is no automated yet high performance tool before. Equnix Data Integration Management (EDIM) comes to the rescue, as a lightweight tools and small memory footprint, running in multi-process way. EDIM is an ETL Tools that is built using C application, very handy to...

Nov 19 Ibrar Ahmed

A Deep Dive into PostgreSQL Indexing

Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index strategy and design. One thing is for sure: not all indexes are appropriate for all circumstances,...

Nov 19 Ujang Jaenudin

Database Migration from Oracle Exadata to PostgreSQL

Migrate Database from Exadata X7 1/8 2 Nodes RAC to PostgreSQL 12.4: Critical OLTP System Peak Transaction around 400 TPS System accessed from million of Mobile devices Critical part: Searching available seats on the route Current workload most likely 80% READ, 20% WRITE PostgresQL able to scale well for READS We plan to have some slaves (Synchronous SR) HA-proxy in front of them

Nov 20 Peter Zaitsev

The Changing Landscape of Open Source Databases

In the current technology landscape, we have a lot of great innovation happening especially when it comes to Database Technology. A few examples include introducing new data models such as time series or graph, which focus on solving SQL at hyper-scale problem, this has been an elusive solution and scale was becoming synonymous with NoSQL environments. We now have a new Cloud-Native database design coming to market using the power of Kubernetes as well as employing Serverless concepts. In...

Nov 20 David Steele

Backup Best Practices with pgBackRest

Backups are a critical part of any enterprise database solution but they are often done poorly or skipped altogether, which can lead to data loss in the event of hardware failure or some other disaster. With the proper tools and procedures data loss can be minimized or entirely avoided, saving valuable enterprise data and time. In this talk we'll cover database backup best practices and how to implement them with pgBackRest, including: WAL archiving Backup frequency and...

Nov 20 Peter Zaitsev

17 Things Developers Need to Know About Databases

Most applications use databases, yet many fail to follow even the most basic best practices causing poor performance, downtime and security incidents. In this presentation, we will look into the foundational best practices you as a Developer should know about databases, with particular focus on the most popular Open Source Databases - MySQL, PostgreSQL, and MongoDB. Introduce the challenge between developers and database operations often existing in an organization Highlight the...

Nov 20 Bruce Momjian

Databases, Containers, and the Cloud

Containers and the cloud are all the rage as companies seek new efficiencies and flexibility. While they are very popular, database use of these facilities is still growing. This talk explores their benefit for database deployments.

Nov 20 Jignesh Shah

Tips and Tricks with Amazon RDS for PostgreSQL

Managed database services are popular for many PostgreSQL users. In this session we look at how best to configure Amazon RDS for PostgreSQL and also look at common user operations of PostgreSQL using Amazon RDS. We will also look beyond common user operations and into some specific optimizations related to upgrade, logical replication, performance, and reducing downtime.

Nov 20 Jim Mlodgenski

Purpose Built Data Types

When designing applications, the database schema is usually an afterthought. When the time comes to finally create the tables, developers normally just use a few base data types, like integers, varchars and timestamps, but PostgreSQL can do more. PostgreSQL's architecture allows for easy extension of data types. In this talk, we will explore some of PostgreSQL's purpose built data types that can reduce the amount of development needed in the application while increasing performance.

Nov 20 Ibrar Ahmed

All about PostgreSQL Security.

PostgreSQL provides different levels of security. This talk will cover all the available security techniques used in PostgreSQL 13. We’ll look at client-side security (LibPq, JDBC) through to server-side security. It will cover all supported authentication methods and the pros and cons of all these methods. Some of the key features of the talk are: - Introduction to Cryptography - SSL, TLS, GSSAPI, and OpenSSL - Client-Side Encryption - Securing Authentication - Securing Data on the disk -...

Nov 20 Amit Kapila

What next in Logical Replication?

Logical replication has been there since 10.0 and with each release, it is getting better. This talk will start with the basic architecture of Logical replication in PostgreSQL and then cover the various ways in which it can be helpful to users. One of the shortcomings of logical replication as compare to physical replication is that currently, it allows the transaction to be replicated only once it is committed. This can create a large apply lag on the subscriber side for long-running...

Nov 20 Yugo Nagata

The Way for Updating Materialized Views Rapidly

Materialized view is a feature to store the results of view definition queries in DB in order to achieve faster query response. However, after base relations are modified, view maintenance is needed to keep the contents up to date. REFRESH MATERIALIZED VIEW command is prepared for the purpose, but this has to recompute the contents from a scratch, so this is not efficient in cases where only a small part of a base table is modified. Incremental View Maintenance (IVM) is a technique to...

Nov 20 Ibrar Ahmed

Tune your Linux Box, not just PostgreSQL

PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. The default configuration is designed in such a way that PostgreSQL can run on any system using minimum resources. Consequently, a default installation of PostgreSQL does not give optimum performance on the high-performance machine because it is set up to use all available resources. PostgreSQL provides mechanisms that allow you to tune...

Nov 20 Andrey Lepikhov

A couple of new features towards the postgres-based sharding

Sharding is a challenge for PostgreSQL developers. It is general purpose tool to achieve query speedup and database scalability. Wherein, PostgreSQL architecture is not ideal for managing relational data in shared-nothing computing architecture. Nowadays, hardly anyone can say with confidence what a practically valuable implementation of sharding in PostgreSQL will looks like. The Development of sharding is moving forward in small steps across hot discussions. In this presentation i want to...

Program

Full Schedule

AsiaChina2020 has the most awesome program ever! See rock-star speakers cover the topics of

Migrations

Top 10 Mistakes When Migrating From Oracle to PostgreSQL by Jim Mlodgenski

Database Migration from Oracle Exadata to PostgreSQL by Ujang Jaenudin

Equnix Data Integration Management, an Automated High Performance ETL Tool for PostgreSQL by Lucky Haryadi

Case Study

Multi-SQL: Development and Practice of Multimodal Data Intelligent Management System by China PostgreSQL Association

Minister of Industry and Information Technology Speech by China PostgreSQL Association

Cost aware data replica management for cloud native database by China PostgreSQL Association

The Ultimate Data Warehouse System by Lucky Haryadi

GIS

Where to stay in Beijing

We recommend these accommodations for your visit.

ZOOM Information

Nov 19 Main Forum

Meeting ID:832 8001 5051 Password: 00042

Nov 19 English Sub Forum A

Meeting ID: 938 6371 8591 Password: 177589

Nov 19 English Sub Forum B

Meeting ID:923 8034 8981 Password: 147483

Nov 20 Main Forum

Meeting ID:831 3473 1063 Password: 783053

Nov 20 English Sub Forum A

Meeting ID:951 2044 1270 Password: 211781

Nov 20 English Sub Forum B

Meeting ID:987 9679 6367 Password: 847713

Nov - 19:

[Main Forum] Live broadcast:

https://www.modb.pro/event/live/235

[Chinese Sub-forum] Live: https://www.modb.pro/event/live/234

[English Sub-forum A] Live room (starting at 11 o'clock): https://www.modb.pro/event/live/233

[English sub-forum B] Live room (starting at 11 o'clock): https://www.modb.pro/event/live/232

CHINA 2020 And PGConf.Asia 2020

Sponsors

Platinum

Golden

Silver

Community

Some of our speakers

Jim Mlodgenski

Bruce Momjian

David Steele

Jignesh Shah

Julyanto SUTANDANG

Ibrar Ahmed

Ahsan Hadi

Peter Zaitsev

Muhammad Usama

Cary Huang

Amit Kapila

Hamid Akhtar

Andrey Lepikhov

Ashutosh Bapat

Yuya Watari

Tatsuo Ishii

Bo Peng

Yugo Nagata

Lucky Haryadi

Yandong Yao

Conference Highlights

Program

Migrations

Case Study

GIS

Security

Cloud

Dev and Ops

Backup and Restores

Performance

Everything about Postgres

Where to stay in Beijing

ZOOM Information