Postgresql logo

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

Sponsors

Platinum

Golden

Silver

Community

Some of our speakers

E938adea42300181ed59bf9656f79e43

Jim Mlodgenski

Amazon Web Services
Principle Database Engineer
Bruce profile

Bruce Momjian

EnterpriseDB
Vice President, Postgres Evangelist
Person 307 128x128

David Steele

Crunchy Data Solutions
Senior Data Architect
Jigneshshah20

Jignesh Shah

Amazon Web Services
Software Development Manager
69fc3df244d34bc5259be88c87e71cb0

Julyanto SUTANDANG

Equnix Business Solutions, PT
Mr
Ibrar

Ibrar Ahmed

Percona LLC
Sr. Software Engineer - PostgreSQL Consultant
096f193be016da51f083a593109491cc

Ahsan Hadi

EnterpriseDB
Pz2

Peter Zaitsev

Percona
CEO
Usama

Muhammad Usama

HighGo
Database architect / PostgreSQL consultant
Cary avatar

Cary Huang

Highgo Software
Software developer
Ag19 amit kapila 9614 selected

Amit Kapila

Fujitsu
Senior Director
94b63c5e87c3bf9dd69d5c878631ef2e

Hamid Akhtar

Highgo Software Inc.
Senior DevOps and Database Architect
Kazan2019 portrait small

Andrey Lepikhov

Postgres Professional
Developer
9f7b8d4e8d33fc6b4080a5060265fcc3

Ashutosh Bapat

2ndQuadrant
PostgreSQL hacker
888be63196abbb13641ff1d91846897f

Yuya Watari

NTT
Researcher
Cf3bf1280bdb74dbbd40878307753990

Tatsuo Ishii

SRA OSS, Inc. Japan
Branch manager
Profile 1

Bo Peng

SRA OSS, Inc. Japan
Engineer
Ea246929448e90e7f331703e14c9c19b

Yugo Nagata

SRA OSS, Inc. Japan
Chief Scientist
84095ff630fe29d1a3b4679697ef587e

Lucky Haryadi

Equnix Business Solutions
Chief Technology Officer
Df788442df909794e047a3a8228a43d8

Yandong Yao

yMatrix Inc.
Founder

Conference Highlights

Nov 19 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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

Backup and Restores

Backup Best Practices with pgBackRest by David Steele

Where to stay in Beijing

We recommend these accommodations for your visit.

Beijing.university

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