CHINA 2020 And PGConf.Asia 2020 Program

2020-11-17
09:00
PostgresConf Organizers PG training - Build a "RAC" enterprise application belonging to postgres

presented by PostgresConf Organizers

Build a "RAC" enterprise application belonging to postgres

Weixing Chen Founder and Chief Lecturer of CUUG

09:00 - 09:40 Virtual Training Room 1
China PostgreSQL Association Alibaba Cloud PostgreSQL ecological cloud native database product

presented by China PostgreSQL Association

Alibaba Cloud PostgreSQL ecological cloud native database product

BY Xiang Zhou

Senior Product Expert of Alibaba Cloud Database

09:00 - 09:40 Virtual Training Room 2
Stephen Frost Bruce Momjian Developer Unconference
Developer Unconference

presented by Stephen Frost and Bruce Momjian

This is a developer unconference.

Hosted by Bruce Momjian

Do come if you have interesting Postgres feature ideas

09:00 - 12:00 Virtual Unconference Room Everything about Postgres
09:40
China PostgreSQL Association The "laser" engine behind the "TPC-H No.1" cloud native data warehouse

presented by China PostgreSQL Association

The "laser" engine behind the "TPC-H No.1" cloud native data warehouse

BY Chuangxian Wei

Senior Technical Expert of Alibaba Cloud Database

09:40 - 10:20 Virtual Training Room 2
PostgreSQL Association China Hands-on practice: in-depth understanding of openGauss architecture

presented by PostgreSQL Association China

Hands-on practice: in-depth understanding of openGauss architecture

BY Dianbin Jiang

Training Director of Enmo Academy

09:40 - 10:20 Virtual Training Room 1
10:20
PostgreSQL Association China New energy industry based on PostgreSQL multi-tenant implementation

presented by PostgreSQL Association China

New energy industry based on PostgreSQL multi-tenant implementation

by Xiaoliang Ma

PG Certified Lecturer of Enmo College

10:20 - 11:00 Virtual Training Room 1
China PostgreSQL Association UnqiueKey: Query rewriting enhancements make your SQL run faster

presented by China PostgreSQL Association

UnqiueKey: Query rewriting enhancements make your SQL run faster

BY Zhihui Fan

Alibaba Cloud Database Technical Expert

10:20 - 11:00 Virtual Training Room 2
11:00
PostgreSQL Association China Explore the theory of PostgreSQL VACUUM

presented by PostgreSQL Association China

Explore the theory of PostgreSQL VACUUM

BY Shaohua Song

PG Certified Lecturer of Shengshu College

11:00 - 12:00 Virtual Training Room 1
China PostgreSQL Association Global Temp Table

presented by China PostgreSQL Association

Global Temp Table

BY Wensheng Zeng

Senior Technical Expert of Alibaba Cloud Database

11:00 - 11:40 Virtual Training Room 2
13:30
China PostgreSQL Association RDS PG security system introduction

presented by China PostgreSQL Association

RDS PG security system introduction

BY Tao Wang

Senior Technical Expert of Alibaba Cloud Database

13:30 - 14:10 Virtual Training Room 2
PostgreSQL Association China PostgreSQL source code interpretation - HASH table algorithm analysis

presented by PostgreSQL Association China

PostgreSQL source code interpretation - HASH table algorithm analysis

BY Haibao Lv

PG Certified Lecturer ofBoxue Education

13:30 - 14:10 Virtual Training Room 1
14:10
China PostgreSQL Association The use of fillfactor in PostgreSQL

presented by China PostgreSQL Association

The use of fillfactor in PostgreSQL BY Tianheng Yu PG Certified Lecturer of Pangu Cloud Classroom

14:10 - 14:50 Virtual Training Room 1
China PostgreSQL Association DTS and its application in PG database ecology

presented by China PostgreSQL Association

DTS and its application in PG database ecology

BY Xu Wang

Senior Technical Expert of Alibaba Cloud Database

14:10 - 14:50 Virtual Training Room 2
14:50
China PostgreSQL Association How does PostgreSQL open the door of the enterprise

presented by China PostgreSQL Association

How does PostgreSQL open the door of the enterprise BY Huayang Liu PG certified lecturer of Dongfang Ruitong

14:50 - 15:30 Virtual Training Room 1
China PostgreSQL Association PG database ecological selection ideas and best practices

presented by China PostgreSQL Association

PG database ecological selection ideas and best practices

BY Wenkai Fan

Alibaba Cloud Database Solution Architect

14:50 - 15:30 Virtual Training Room 2
15:30
China PostgreSQL Association PostgreSQL Backup and Recovery

presented by China PostgreSQL Association

PostgreSQL Backup and Recovery

BY Ziwen Wu

PG Certified Lecturer of Copley Academy

15:30 - 16:10 Virtual Training Room 1
China PostgreSQL Association Best Practices for PostgreSQL CDC

presented by China PostgreSQL Association

Best Practices for PostgreSQL CDC

BY Jian Wang

Senior Operation and Maintenance Engineer of Alibaba Cloud Database

15:30 - 16:10 Virtual Training Room 2
16:10
China PostgreSQL Association The advantages and practice of PostgreSQL in data warehouse

presented by China PostgreSQL Association

The advantages and practice of PostgreSQL in data warehouse

BY Fu Shi

PG Certified Lecturer of Bosenrui College

16:10 - 16:50 Virtual Training Room 1
16:50
China PostgreSQL Association The theory and actual combat of Oracle migration to PostgreSQL

presented by China PostgreSQL Association

The advantages and practice of PostgreSQL in data warehouse

BY Fu Shi

PG Certified Lecturer of Bosenrui College

16:50 - 17:30 Virtual Training Room 1
2020-11-18
09:00
China PostgreSQL Association HGDB security mechanism

presented by China PostgreSQL Association

HGDB security mechanism BY Shijie Xian Senior Engineer of Highgo Software

09:00 - 10:00 Highgo Training Room - CN
China PostgreSQL Association TBase open source distributed database-exploration in the field of HTAP

presented by China PostgreSQL Association

TBase open source distributed database-exploration in the field of HTAP BY Xin Wu Tencent Cloud Database Expert Engineer

09:00 - 09:40 Tencent Training Room - CN
China PostgreSQL Association Data processing more than billion rows per second

presented by China PostgreSQL Association

Data processing more than billion rows per second BY Kohei KaiGai

09:00 - 09:40 PostgresConf Special Training Room - English
09:40
China PostgreSQL Association Database Isolation Levels, Data Issues and Global Transaction Consistency

presented by China PostgreSQL Association

Database Isolation Levels, Data Issues and Global Transaction Consistency

BY Jim Walker & Chris Casano

09:40 - 10:20 PostgresConf Special Training Room - English
China PostgreSQL Association CynosDB for PG —— Storage cluster management

presented by China PostgreSQL Association

CynosDB for PG —— Storage cluster management BY Jin Lin Senior Engineer of Tencent Cloud Database

09:40 - 10:20 Tencent Training Room - CN
10:00
China PostgreSQL Association HGDB backup and restore

presented by China PostgreSQL Association

HGDB backup and restore BY Yunhe Xu Senior Engineer of Highgo Software

10:00 - 10:40 Highgo Training Room - CN
10:20
China PostgreSQL Association PGX: Build Postgres Extensions with Rust

presented by China PostgreSQL Association

PGX: Build Postgres Extensions with Rust

BY Eric Ridge

10:20 - 11:00 PostgresConf Special Training Room - English
China PostgreSQL Association CynosDB for PG —— Master-slave architecture

presented by China PostgreSQL Association

CynosDB for PG —— Master-slave architecture BY Lixian Zou Tencent Cloud Database Expert Engineer

10:20 - 11:00 Tencent Training Room - CN
10:40
China PostgreSQL Association Talk about WAL files in detail

presented by China PostgreSQL Association

Talk about WAL files in detail BY Xiao Yu Senior Engineer of Highgo Software

10:40 - 11:20 Highgo Training Room - CN
11:00
China PostgreSQL Association CynosDB for PG —— Backup and restore

presented by China PostgreSQL Association

CynosDB for PG —— Backup and restore BY Aiguo Zhang Senior Engineer of Tencent Cloud Database

11:00 - 11:40 Tencent Training Room - CN
China PostgreSQL Association JP Phillips Using PostgreSQL and Friends for a Street Sweeping Solver Project

presented by China PostgreSQL Association and JP Phillips

Using PostgreSQL and Friends for a Street Sweeping Solver Project

BY James E. Marca

11:00 - 11:40 PostgresConf Special Training Room - English
13:30
China PostgreSQL Association HGDB-Sabre-Migration efficient database migration tool

presented by China PostgreSQL Association

HGDB-Sabre-Migration efficient database migration tool

BY Zhenchao Qiu

Senior Engineer of Highgo Software

13:30 - 14:10 Highgo Training Room - CN
China PostgreSQL Association Logical Replication lessons learned for the Data Warehouse

presented by China PostgreSQL Association

Logical Replication lessons learned for the Data Warehouse

BY Pat Wright

13:30 - 14:10 PostgresConf Special Training Room - English
China PostgreSQL Association What can PG be used for

presented by China PostgreSQL Association

What can PG be used for BY Yang Tang Tencent Cloud Database Product Manager

13:30 - 14:10 Tencent Training Room - CN
14:10
China PostgreSQL Association TencentDB for PG —— High availability practice

presented by China PostgreSQL Association

TencentDB for PG —— High availability practice BY Hui Huang Senior Engineer of Tencent Cloud Database

14:10 - 14:50 Tencent Training Room - CN
China PostgreSQL Association PostgreSQL Parallelism Do’s and Don’ts

presented by China PostgreSQL Association

PostgreSQL Parallelism Do’s and Don’ts

BY Sebastian Dressler

14:10 - 14:50 PostgresConf Special Training Room - English
China PostgreSQL Association HGDB-JAVA application migration experience sharing

presented by China PostgreSQL Association

HGDB-JAVA application migration experience sharing

BY Mingguo Yang

Senior Engineer of Highgo Software

14:10 - 15:10 Highgo Training Room - CN
14:50
China PostgreSQL Association TencentDB for PG —— serverless

presented by China PostgreSQL Association

TencentDB for PG —— serverless BY Ting Tang Senior Engineer of Tencent Cloud Database

14:50 - 15:30 Tencent Training Room - CN
China PostgreSQL Association Monitoring Strategy Considerations

presented by China PostgreSQL Association

Monitoring Strategy Considerations

BY David Orlandi

14:50 - 15:30 PostgresConf Special Training Room - English
15:10
China PostgreSQL Association HGDB-Server-side advanced programming

presented by China PostgreSQL Association

HGDB-Server-side advanced programming BY Haiqing Li Senior Engineer of Highgo Software

15:10 - 16:10 Highgo Training Room - CN
15:30
China PostgreSQL Association CYPEX: Revolutionizing PostgreSQL Application Development

presented by China PostgreSQL Association

CYPEX: Revolutionizing PostgreSQL Application Development

BY Hans-Jürgen Schönig

15:30 - 16:10 PostgresConf Special Training Room - English
China PostgreSQL Association Waiting for event —— buffer_content analysis

presented by China PostgreSQL Association

Waiting for event —— buffer_content analysis BY Zhichuan Zhang Senior Engineer of Tencent Cloud Database

15:30 - 16:10 Tencent Training Room - CN
2020-11-19
09:00
China PostgreSQL Association Opening and Fellow Speech

presented by China PostgreSQL Association

Opening & Fellow Speech

09:00 - 09:10 Virtual - English Main Conference
China PostgreSQL Association Construction of distributed database middleware ecosystem based on PostgreSQL

presented by China PostgreSQL Association

Construction of distributed database middleware ecosystem based on PostgreSQL BY Juan Pan Senior DBA oF jddglobal

09:00 - 09:40 Virtual - Mandarin Sun-conference
09:10
China PostgreSQL Association Minister of Industry and Information Technology Speech

presented by China PostgreSQL Association

Minister of Industry and Information Technology Speech

BY CHINA Minister of Industry and Information Technology

09:10 - 09:20 Virtual - English Main Conference Case Study
09:20
Bruce Momjian Will Postgres Live Forever?

presented by Bruce Momjian

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.

09:20 - 10:00 Virtual - English Main Conference Everything about Postgres
09:40
China PostgreSQL Association Exploration of database software and hardware collaborative optimization

presented by China PostgreSQL Association

Exploration of database software and hardware collaborative optimization BY Hanyi Wang Head of ZTE Analytical Database

09:40 - 10:20 Virtual - Mandarin Sun-conference
10:00
Tatsuo Ishii Wonderful PostgreSQL!
The history of PostgreSQL

presented by Tatsuo Ishii

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 rece...

more

10:00 - 10:40 Virtual - English Main Conference Everything about Postgres
10:20
China PostgreSQL Association PostgreSQL difficult case sharing

presented by China PostgreSQL Association

PostgreSQL difficult case sharing BY Guochao Zhou Senior Cloud Database Engineer.database product team,PingAn Technolo

10:20 - 11:00 Virtual - Mandarin Sun-conference
10:40
China PostgreSQL Association My Way from PG to TOTEM

presented by China PostgreSQL Association

My Way from PG to TOTEM BY Zhiyong Peng Deputy Director of the Database Committee of China Computer Federation, Professor of School of Computer Science, Wuhan University

10:40 - 11:20 Virtual - English Main Conference
11:00
Jim Mlodgenski Top 10 Mistakes When Migrating From Oracle to PostgreSQL

presented by Jim Mlodgenski

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.

11:00 - 11:40 Virtual - English Sub-Conference B Migrations
China PostgreSQL Association Implementation of Brin Index in Append Only Table

presented by China PostgreSQL Association

Implementation of Brin Index in Append Only Table BY Jinbao Chen VMWare Greenplum Senior R&D Engineer

11:00 - 11:40 Virtual - Mandarin Sun-conference
Bruce Momjian Postgres and the Artificial Intelligence Landscape

presented by Bruce Momjian

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 wei...

more

11:00 - 11:40 Virtual - English Sub-Conference A Everything about Postgres
11:20
China PostgreSQL Association Observing the elephant: the skills migration from Oracle to PostgreSQL DBA

presented by China PostgreSQL Association

Observing the elephant: the skills migration from Oracle to PostgreSQL DBA BY Guoqiang Gai Founder of Enmotech

11:20 - 12:00 Virtual - English Main Conference
13:30
China PostgreSQL Association K1 power and PostgreSQL help enterprises to build new normal and new core

presented by China PostgreSQL Association

K1 power and PostgreSQL help enterprises to build new normal and new core

BY Shuxin Fang

General manager of technical support,Inspur Business Machine Company

13:30 - 14:10 Virtual - English Main Conference
Yandong Yao large scale time series database based on PostgreSQL for PB scale data

presented by Yandong Yao

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...

more

13:30 - 14:10 Virtual - English Sub-Conference A Everything about Postgres
China PostgreSQL Association Comparative understanding of PostgreSQL, MySQL and Oracle

presented by China PostgreSQL Association

Comparative understanding of PostgreSQL, MySQL and Oracle BY Bo Wei Director of China PostgreSQL Training and Certification

13:30 - 14:10 Virtual - Mandarin Sun-conference
Cary Huang Understand TLS Features as an administrator of PostgreSQL Server

presented by Cary Huang

TLS is one of the most common but least understood protocol used to secure network connections today. PostgreSQL has a very good support of TLS and today I will explain the important principles behind TLS so you, as a PostgreSQL database administrator, can understand the protocol better and select the most proper security settings in your setup.

Topics to discuss include:

  • TLS versions. ...
more

13:30 - 14:10 Virtual - English Sub-Conference B Security
14:10
Julyanto SUTANDANG PostgreSQL Global Certification
Certification is a key component to build a great Business Ecosystem for PostgreSQL. With great business ecosystem, PostgreSQL will penetrate deeper.

presented by Julyanto SUTANDANG

Introduction

PostgreSQL has gain great traction in business world, it is becoming a new standard in Financial Institution and Telecommunication Industry. It is a great appreciation from public especially business users, to acknowledge and trust PostgreSQL as part of their day to day mission critical business operation. While there are a great demand, but we lack of some key factor ...

more

14:10 - 14:50 Virtual - English Sub-Conference B Everything about Postgres
Ahsan Hadi Better late then never - Stored Procedures in PG 11

presented by Ahsan Hadi

Finally we have stroed procedures in PostgreSQL 11, better late then never. PostgreSQL versions prior to 11 only supported functions, the support for stored procedures was added in PostgreSQL 11. It is added as a new schema object which is similar to functions and but without a return value and with some subtle differneces and benefits.

The main benefits of Stored procedure are the followin...

more

14:10 - 14:50 Virtual - English Sub-Conference A Everything about Postgres
PostgreSQL Association China Ottertune-Database parameter auto tuning tool and its implementation

presented by PostgreSQL Association China

Ottertune-Database parameter auto tuning tool and its implementation BY Bohan Zhang Co-founder of Ottertune

14:10 - 14:50 Virtual - Mandarin Sun-conference
China PostgreSQL Association Database Development Trend

presented by China PostgreSQL Association

Database Development Trend BY Zhengsheng Ye Senior product expert of Alibaba Group, head of product management and operation of Alibaba Cloud intelligent database

14:10 - 14:50 Virtual - English Main Conference
14:50
China PostgreSQL Association PostgreSQL deep learning and maintenance management methodology

presented by China PostgreSQL Association

PostgreSQL deep learning and maintenance management methodology BY Caibo Yue Senior Product Manager of HighGo Software

14:50 - 15:30 Virtual - Mandarin Sun-conference
Yuya Watari Speeding Up Analytic Queries by Sharing Commonalities
Speeding Up Analytic Queries by Sharing Commonalities

presented by Yuya Watari

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 ...

more

14:50 - 15:30 Virtual - English Sub-Conference A Performance
Ashutosh Bapat Optimizing queries involving partitioned tables
divide and conquer comes to SQL

presented by Ashutosh Bapat

Introduced in PostgreSQL 10, partitioned tables are becoming a main stream feature of PostgreSQL. When combined with FDW esp. postgres_fdw, these two technologies form a base for distributed query processing in a sharded setup.

Partitioned table distribute the data into smaller chunks or when coupled with FDW they distribute the data across multiple servers. PostgreSQL's query optimizer take...

more

14:50 - 15:30 Virtual - English Sub-Conference B Performance
China PostgreSQL Association Wechat Pay

presented by China PostgreSQL Association

Wechat Pay BY Yicheng Wang Deputy General Manager of Tencent Cloud Database

14:50 - 15:30 Virtual - English Main Conference
15:30
Asif Rehman Advanced PostgreSQL Replication

presented by Asif Rehman

Replication is the process of copying and maintaining database objects, such as tables, in multiple databases that make up a distributed database system. There are various benefits of replication which makes it an important component of any enterprise-level database deployment. The main drivers for replication are high availability, performance, load balancing, and others.

PostgreSQL offers ...

more

15:30 - 16:10 Virtual - English Sub-Conference B
Lucky Haryadi Equnix Data Integration Management, an Automated High Performance ETL Tool for PostgreSQL
an Automated High Performance ETL Tool for PostgreSQL

presented by Lucky Haryadi

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, run...

more

15:30 - 16:10 Virtual - English Sub-Conference A Migrations
China PostgreSQL Association Thinking and exploration of reading and writing separation of PostgreSQL

presented by China PostgreSQL Association

Thinking and exploration of reading and writing separation of PostgreSQL BY Biao Sun Senior R&D Engineer of HighGo Software

15:30 - 16:10 Virtual - Mandarin Sun-conference
China PostgreSQL Association Review of Commercial Database Technology Innovation

presented by China PostgreSQL Association

Review of Commercial Database Technology Innovation BY Xiaojun Zheng Chief Scientist of HighGo Software

15:30 - 16:10 Virtual - English Main Conference
16:10
Ujang Jaenudin Database Migration from Oracle Exadata to PostgreSQL
Tune converted pl/pgsql core Function

presented by Ujang Jaenudin

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

16:10 - 16:50 Virtual - English Sub-Conference B Migrations
China PostgreSQL Association Database High Availability

presented by China PostgreSQL Association

Database High Availability BY Wei Liu Researcher at Enmotech

16:10 - 16:50 Virtual - Mandarin Sun-conference
Ibrar Ahmed A Deep Dive into PostgreSQL Indexing

presented by Ibrar Ahmed

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...

more

16:10 - 16:50 Virtual - English Sub-Conference A Performance
China PostgreSQL Association 2020 PG China Technology Selection Release Ceremony

presented by China PostgreSQL Association

2020 PG China Technology Selection Release Ceremony

16:10 - 16:20 Virtual - English Main Conference Everything about Postgres
16:20
China PostgreSQL Association China PG ACE Release Ceremony

presented by China PostgreSQL Association

China PG ACE Release Ceremony

16:20 - 16:30 Virtual - English Main Conference
16:40
China PostgreSQL Association China PGCM Release Ceremony

presented by China PostgreSQL Association

China PGCM Release Ceremony

16:40 - 16:50 Virtual - English Main Conference
16:50
China PostgreSQL Association Migration points of PostgreSQL hybrid cloud database

presented by China PostgreSQL Association

Migration points of PostgreSQL hybrid cloud database BY Feixiang Zhao Senior DBA of Airwallex

16:50 - 17:30 Virtual - Mandarin Sun-conference
China PostgreSQL Association Cloud Native Database Products for PostgreSQL on Alibaba Cloud

presented by China PostgreSQL Association

Cloud Native Database Products for PostgreSQL on Alibaba Cloud

By XIANG ZHOU

Staff Product Manager, Database Group, Alibaba Cloud

16:50 - 17:30 Virtual - English Sub-Conference B
17:00
China PostgreSQL Association China Developer Community and PanGu Agreement Release Ceremony

presented by China PostgreSQL Association

China Developer Community and PanGu Agreement Release Ceremony

17:00 - 17:10 Virtual - English Main Conference
17:10
China PostgreSQL Association The First National University PG Technical Competition Release Ceremony

presented by China PostgreSQL Association

The First National University PG Technical Competition Release Ceremony

17:10 - 17:30 Virtual - English Main Conference
17:30
China PostgreSQL Association PG application based on microservice architecture

presented by China PostgreSQL Association

PG application based on microservice architecture BY Xue Wang Engineer of software R&D center of a state-owned bank

17:30 - 18:10 Virtual - Mandarin Sun-conference
2020-11-20
09:00
China PostgreSQL Association Application and practice of PostgreSQL in Suning

presented by China PostgreSQL Association

Application and practice of PostgreSQL in Suning BY Huajun Chen Suning Database Expert

09:00 - 09:40 Virtual - Mandarin Sun-conference
 Peter Zaitsev The Changing Landscape of Open Source Databases
A discussion on the changes, trends, and database technologies that are going to impact your business in the next 12-18 months.

presented by Peter Zaitsev

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 de...

more

09:00 - 09:40 Virtual - English Main Conference Everything about Postgres
09:40
China PostgreSQL Association The scalpel of the tangential Core: Practice to improve PostgreSQL I/O performance

presented by China PostgreSQL Association

The scalpel of the tangential Core: Practice to improve PostgreSQL I/O performance BY Haibo Lv MeiChuang Database Core Researcher

09:40 - 10:20 Virtual - Mandarin Sun-conference
Lindsay Hooper Pay it forward

presented by Lindsay Hooper

Pay it forward

TBD

09:40 - 10:00 Virtual - English Main Conference
10:00
Lei Feng Greenplum's open source journey: ecology and community leadership

presented by Lei Feng

Greenplum's open source journey: ecology and community leadership

BY RAY FENG

10:00 - 10:40 Virtual - English Main Conference Everything about Postgres
10:20
China PostgreSQL Association Principle and analysis of flashback tool based on wal log analysis in a PG branch

presented by China PostgreSQL Association

Principle and analysis of flashback tool based on wal log analysis in a PG branch BY Hui Lv Enmoedu Database core Development Engineer

10:20 - 11:00 Virtual - Mandarin Sun-conference
10:30
 Peter Zaitsev 17 Things Developers Need to Know About Databases
Foundational best practices you as a Developer should know about databases

presented by Peter Zaitsev

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 cha...
more

10:30 - 11:10 Virtual - English Sub-Conference A Everything about Postgres
David Steele Backup Best Practices with pgBackRest

presented by David Steele

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 ...

more

10:30 - 11:10 Virtual - English Sub-Conference B Backup and Restores
10:40
China PostgreSQL Association Opportunities and Challenges of Cloud Native Data Warehouse

presented by China PostgreSQL Association

Opportunities and Challenges of Cloud Native Data Warehouse BY Chaoqun Zhan Researcher of Alibaba Group, Head of OLAP Product Department of Database Product Division

10:40 - 11:20 Virtual - English Main Conference
11:00
China PostgreSQL Association Best practice of database intelligent parameter adjustment based on Reinforcement Learning

presented by China PostgreSQL Association

Best practice of database intelligent parameter adjustment based on Reinforcement Learning BY Zhongliang Li Senior System Architect, ZTE

11:00 - 11:40 Virtual - Mandarin Sun-conference
11:10
Jignesh Shah Tips and Tricks with Amazon RDS for PostgreSQL
"I did not know you can do that!"

presented by Jignesh Shah

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.

11:10 - 11:50 Virtual - English Sub-Conference B Cloud
Bruce Momjian Databases, Containers, and the Cloud

presented by Bruce Momjian

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.

11:10 - 11:50 Virtual - English Sub-Conference A Cloud
13:30
Jim Mlodgenski Purpose Built Data Types

presented by Jim Mlodgenski

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 ca...

more

13:30 - 14:10 Virtual - English Sub-Conference B Dev and Ops
China PostgreSQL Association Technology development of a new generation distribued database tbase based on PostgreSQL

presented by China PostgreSQL Association

Technology development of a new generation distribued database tbase based on PostgreSQL BY Yuesen Li Technical Director of Tencent Cloud TBase Database

13:30 - 14:10 Virtual - English Main Conference
Ibrar Ahmed All about PostgreSQL Security.

presented by Ibrar Ahmed

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, GSS...

more

13:30 - 14:10 Virtual - English Sub-Conference A Security
China PostgreSQL Association PostgreSQL 13 New Features

presented by China PostgreSQL Association

PostgreSQL 13 New Features BT Yanliang Lei Senior Database Director of HighGo Software

13:30 - 14:10 Virtual - Mandarin Sun-conference
China PostgreSQL Association Data sharing technology based on blockchain

presented by China PostgreSQL Association

Data sharing technology based on blockchain BY Cheqing Jin Professor/Ph.D. Supervisor, School of Data Science and Engineering, East China Normal University

13:30 - 14:10 Virtual - Mandarin Industry University and Research Sub-conference
14:10
China PostgreSQL Association Application-oriented database benchmarking

presented by China PostgreSQL Association

Application-oriented database benchmarking BY Rong Zhang Professor/Ph.D. Supervisor, School of Data Science and Engineering, East China Normal University

14:10 - 14:50 Virtual - Mandarin Industry University and Research Sub-conference
Bo Peng Deploying PostgreSQL Cluster with Query Load Balancing and Monitoring Capabilities on Kubernetes

presented by Bo Peng

Kubernetes is an open source container orchestration platform for automating deployment, scaling and management of application containers. Nowadays, more and more applications are being deployed in containers on Kubernetes.

There are several solutions that can help us to run a PostgreSQL cluster on Kubernetes. However, these solutions don't provide query load balancing capability.

In this...

more

14:10 - 14:50 Virtual - English Main Conference Everything about Postgres
China PostgreSQL Association Discover Greenplum distributed lock

presented by China PostgreSQL Association

Discover Greenplum distributed lock BY Zhenghua Lv Senior R&D Engineer at VMWare Greenplum

14:10 - 14:50 Virtual - Mandarin Sun-conference
Amit Kapila What next in Logical Replication?

presented by Amit Kapila

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 onl...

more

14:10 - 14:50 Virtual - English Sub-Conference B Everything about Postgres
Hamid Akhtar PostgreSQL High Availability: The Considerations and Candidates

presented by Hamid Akhtar

Almost every organisation that I interact with wants a high availability system for PostgreSQL. This clearly depicts an active trend toward an increase in utilising PostgreSQL for critical business applications. In some cases it is a move away from other major database systems like Oracle or even Teradata.

We are going to define the basic criteria for a high availability system, and have a q...

more

14:10 - 14:50 Virtual - English Sub-Conference A Everything about Postgres
14:50
Yugo Nagata The Way for Updating Materialized Views Rapidly

presented by Yugo Nagata

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 ...

more

14:50 - 15:30 Virtual - English Sub-Conference A Everything about Postgres
China PostgreSQL Association Research and Development of Unified model and Language of Knowledge Graph Database Management System

presented by China PostgreSQL Association

Research and Development of Unified model and Language of Knowledge Graph Database Management System

BY Xin Wang

Deputy Dean, School of Artificial Intelligence, Tianjin University

14:50 - 15:30 Virtual - Mandarin Industry University and Research Sub-conference Everything about Postgres
China PostgreSQL Association Practice of traditional database migration to heterogeneous cloud

presented by China PostgreSQL Association

Practice of traditional database migration to heterogeneous cloud BY Guosheng Han Senior Product Expert of Alibaba Cloud Database

14:50 - 15:30 Virtual - English Main Conference
 Muhammad Usama PostgreSQL HA with Pgpool-II and whats been happening in Pgpool-II lately....
Load balancing and HA with Pgpool-II

presented by Muhammad Usama

Pgpool-II has been around to complement PostgreSQL over a decade and provides many features like connection pooling, failover, query caching, load balancing, and HA. High Availability (HA) is very critical to most enterprise application, the clients needs the ability to automatically reconnect with a secondary node when the primary nodes goes down.

This is where Pgpool-II watchdog feature co...

more

14:50 - 15:30 Virtual - English Sub-Conference B Dev and Ops
China PostgreSQL Association Parallel AGG, data analysis is one step faster

presented by China PostgreSQL Association

Parallel AGG, data analysis is one step faster BY Hongbo Dang Head of AntDB Product Planning and Product Delivery, AsiaInfo

14:50 - 15:30 Virtual - Mandarin Sun-conference
15:30
Ibrar Ahmed Tune your Linux Box, not just PostgreSQL

presented by Ibrar Ahmed

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 i...

more

15:30 - 16:10 Virtual - English Sub-Conference B Performance
China PostgreSQL Association Greenplum's PG Core upgrade

presented by China PostgreSQL Association

Greenplum's PG Core upgrade BY Xiaoliang Li Senior R&D Engineer at VMWare Greenplum

15:30 - 16:10 Virtual - Mandarin Sun-conference
China PostgreSQL Association The Next Generation Cloud Database Form

presented by China PostgreSQL Association

The Next Generation Cloud Database Form BY Zhengzhong Zhou Alibaba Cloud Database Product Expert

15:30 - 16:10 Virtual - English Main Conference
China PostgreSQL Association Multi-SQL: Development and Practice of Multimodal Data Intelligent Management System

presented by China PostgreSQL Association

Multi-SQL: Development and Practice of Multimodal Data Intelligent Management System

BY Hongzhi Wang

Professor/Ph.D. Supervisor of Harbin Institute of Technology

15:30 - 16:10 Virtual - Mandarin Industry University and Research Sub-conference Case Study
Lucky Haryadi The Ultimate Data Warehouse System

presented by Lucky Haryadi

Data Warehouse became part of the main "vein" on Enterprise Solution, as it stores a huge historical of Enterprise transactions for supporting strategic decisions and giving intelligent insight for management. Data Warehouse is the right choice for Business since every structured transaction requires a systematic, multidimensional structure, and comprehensive data aggregation resulted in soph...

more

15:30 - 16:10 Virtual - English Sub-Conference A Case Study
16:10
Naresh Kumar Inna Keshav Prasad Scaling PostgreSQL with persistent memory

presented by Naresh Kumar Inna and Keshav Prasad

In this talk, we describe how Persistent Memory (PMEM) can be used to vertically scale up PostgreSQL. We look at how PMEM can be used in both the storage and memory access paths of PostgreSQL. While persistent memory is traditionally used to store and speed up WAL in PostgreSQL, we look at other interesting possibilities. For example, we discuss using PMEM as a large persistent cache for the ...

more

16:10 - 16:50 Virtual - English Sub-Conference B Performance
Andrey Lepikhov A couple of new features towards the postgres-based sharding
CSN-based snapshot, shippable tables, fast copy from and dump/restore relation statistics

presented by Andrey Lepikhov

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 ...

more

16:10 - 16:50 Virtual - English Sub-Conference A Performance
China PostgreSQL Association Riding the cloud, the development road of ADB cloud native data warehouse

presented by China PostgreSQL Association

Riding the cloud, the development road of ADB cloud native data warehouse BY Feng Han Senior Product Expert of Alibaba Cloud Database

16:10 - 16:50 Virtual - English Main Conference
China PostgreSQL Association Initial exploration of citus and pgpool in geographic information industry

presented by China PostgreSQL Association

Initial exploration of citus and pgpool in geographic information industry BY Hang Liu Senior R&D Engineer, Geo-Compass

16:10 - 16:50 Virtual - Mandarin Sun-conference
China PostgreSQL Association Cost aware data replica management for cloud native database

presented by China PostgreSQL Association

Cost aware data replica management for cloud native database

BY Wei He

Associate Professor, School of Software, Shandong University

16:10 - 16:50 Virtual - Mandarin Industry University and Research Sub-conference Case Study
16:50
China PostgreSQL Association Database cloudification-direction, path and technology

presented by China PostgreSQL Association

Database cloudification-direction, path and technology BY Xianwen Zhu Founder and General Manager of Chengdu Wenwu Information Technology Co., Ltd.

16:50 - 17:30 Virtual - English Main Conference
China PostgreSQL Association Hytera's PostgreSQL Microservice Architecture

presented by China PostgreSQL Association

Hytera's PostgreSQL Microservice Architecture BY Peng Cui Hytera Senior R&D Engineer of Hytera

16:50 - 17:30 Virtual - Mandarin Sun-conference
17:30
China PostgreSQL Association Multi-Master Horizontal Expansion Cross PostgreSQL and MySQL

presented by China PostgreSQL Association

Multi-Master Horizontal Expansion Cross PostgreSQL and MySQL BY Shaocong Xiao Senior Technical Director of Jushan Database

17:30 - 18:10 Virtual - English Main Conference