CHINA 2020 And PGConf.Asia 2020 Program

presented by PostgresConf Organizers

Build a "RAC" enterprise application belonging to postgres

Weixing Chen Founder and Chief Lecturer of CUUG

presented by China PostgreSQL Association

Alibaba Cloud PostgreSQL ecological cloud native database product

BY Xiang Zhou

Senior Product Expert of Alibaba Cloud Database

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

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

presented by PostgreSQL Association China

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

BY Dianbin Jiang

Training Director of Enmo Academy

presented by China PostgreSQL Association

UnqiueKey: Query rewriting enhancements make your SQL run faster

BY Zhihui Fan

Alibaba Cloud Database Technical Expert

presented by PostgreSQL Association China

New energy industry based on PostgreSQL multi-tenant implementation

by Xiaoliang Ma

PG Certified Lecturer of Enmo College

presented by PostgreSQL Association China

Explore the theory of PostgreSQL VACUUM

BY Shaohua Song

PG Certified Lecturer of Shengshu College

presented by China PostgreSQL Association

Global Temp Table

BY Wensheng Zeng

Senior Technical Expert of Alibaba Cloud Database

presented by China PostgreSQL Association

RDS PG security system introduction

BY Tao Wang

Senior Technical Expert of Alibaba Cloud Database

presented by PostgreSQL Association China

PostgreSQL source code interpretation - HASH table algorithm analysis

BY Haibao Lv

PG Certified Lecturer ofBoxue Education

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

DTS and its application in PG database ecology

BY Xu Wang

Senior Technical Expert of Alibaba Cloud Database

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

PG database ecological selection ideas and best practices

BY Wenkai Fan

Alibaba Cloud Database Solution Architect

presented by China PostgreSQL Association

Best Practices for PostgreSQL CDC

BY Jian Wang

Senior Operation and Maintenance Engineer of Alibaba Cloud Database

presented by China PostgreSQL Association

PostgreSQL Backup and Recovery

BY Ziwen Wu

PG Certified Lecturer of Copley Academy

presented by China PostgreSQL Association

The advantages and practice of PostgreSQL in data warehouse

BY Fu Shi

PG Certified Lecturer of Bosenrui College

presented by China PostgreSQL Association

The advantages and practice of PostgreSQL in data warehouse

BY Fu Shi

PG Certified Lecturer of Bosenrui College

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

Data processing more than billion rows per second BY Kohei KaiGai

presented by China PostgreSQL Association

HGDB security mechanism BY Shijie Xian Senior Engineer of Highgo Software

presented by China PostgreSQL Association

Database Isolation Levels, Data Issues and Global Transaction Consistency

BY Jim Walker & Chris Casano

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

PGX: Build Postgres Extensions with Rust

BY Eric Ridge

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association and JP Phillips

Using PostgreSQL and Friends for a Street Sweeping Solver Project

BY James E. Marca

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

HGDB-Sabre-Migration efficient database migration tool

BY Zhenchao Qiu

Senior Engineer of Highgo Software

presented by China PostgreSQL Association

Logical Replication lessons learned for the Data Warehouse

BY Pat Wright

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

HGDB-JAVA application migration experience sharing

BY Mingguo Yang

Senior Engineer of Highgo Software

presented by China PostgreSQL Association

PostgreSQL Parallelism Do’s and Don’ts

BY Sebastian Dressler

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

Monitoring Strategy Considerations

BY David Orlandi

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

CYPEX: Revolutionizing PostgreSQL Application Development

BY Hans-Jürgen Schönig

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

Opening & Fellow Speech

presented by China PostgreSQL Association

Minister of Industry and Information Technology Speech

BY CHINA Minister of Industry and Information Technology

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.

presented by China PostgreSQL Association

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

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

presented by China PostgreSQL Association

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

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

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.

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

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

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

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

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

presented by China PostgreSQL Association

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

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

presented by PostgreSQL Association China

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

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

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

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

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

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

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

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

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

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

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

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

2020 PG China Technology Selection Release Ceremony

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

presented by China PostgreSQL Association

Database High Availability BY Wei Liu Researcher at Enmotech

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

presented by China PostgreSQL Association

China PG ACE Release Ceremony

presented by China PostgreSQL Association

China PGCM Release Ceremony

presented by China PostgreSQL Association

Cloud Native Database Products for PostgreSQL on Alibaba Cloud

By XIANG ZHOU

Staff Product Manager, Database Group, Alibaba Cloud

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

China Developer Community and PanGu Agreement Release Ceremony

presented by China PostgreSQL Association

The First National University PG Technical Competition Release Ceremony

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

presented by China PostgreSQL Association

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

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

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

presented by Lindsay Hooper

Pay it forward

TBD

presented by Lei Feng

Greenplum's open source journey: ecology and community leadership

BY RAY FENG

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

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

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

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

presented by China PostgreSQL Association

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

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.

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.

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

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

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

presented by China PostgreSQL Association

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

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

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

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

presented by China PostgreSQL Association

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

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

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

presented by China PostgreSQL Association

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

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

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

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

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

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

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

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

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

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

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

presented by China PostgreSQL Association

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

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

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

presented by China PostgreSQL Association

Cost aware data replica management for cloud native database

BY Wei He

Associate Professor, School of Software, Shandong University

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.

presented by China PostgreSQL Association

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

presented by China PostgreSQL Association

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