Beijing 2019 Program

presented by PostgresConf Organizers

Registration at the reception area. For July 3, it is invited only meeting. For July 4, attendees need to pick up his/her tickets at the reception.

presented by Jian Miao

The general talk about the PG association

presented by Joshua Drake

Introduce the new International Consultant Committee members

presented by PostgresConf Organizers

That's the internal meeting of PostgreSQL Association, International Consultant Committee meeting.

presented by PostgresConf Organizers

presented by PostgresConf Organizers

Announce the opening of the conference

presented by Officer Representative

Officer representative speech from the government. Emphasize the importance of the Open-source Postgres

presented by Guangnan Ni

Speech by Ni Guangnan, member of China Engineering Academy

presented by PostgresConf Organizers

PG Annual Technology Awards Ceremony To award the PostgreSQL technology best practices in China

presented by Joshua D. Drake

The PostgreSQL industry, ecosystem etc

presented by Fei Fei Li

The speech is provided by Dr. Fei Fei, Li. He will demonstrate the Alibaba Cloud and database, in addition, the applications in China

presented by PostgresConf Organizers

The lunch break, 50 minutes

presented by Xiao Jun Zheng

The topic will be update later

presented by Lei Jun Hu

The topic is to be updated

presented by PostgresConf Organizers

Coffee Break

presented by Shao Cong Xiao

Topic details to be updated later

presented by Yang Wang

The topic is to be updated

presented by Wen Sheng Zhang

The topic is to be updated

presented by Joshua Drake, Oleg Bartunov, Xiao Jun Zheng, Grant Zhou, and Michael Meskes

Traditional Dialogue Program

presented by PostgresConf Organizers

The social event will be held in the Cafe area of the hotel from 18:30. Register before you could attend.

presented by Joshua Drake

PostgreSQL V12 is set to hit the streets in just a couple of months and is currently in Beta. Join with Joshua D. Drake (JD), the Founder of United States PostgreSQL and Co-Chair of Postgres Conference, the largest Postgres Conference series in the world on a fantastic journey of what makes PostgreSQL v12: Fully baked!

presented by Ning Zhen Li

Open source software compliance discussion

presented by daming shao

The kernel analysis of PG parser.

presented by Michael Meskes

No single Open Source project can exist all by itself, all software tools run in an environment that consists of a lot of other software, most if not all of which again can be Open Source. Likewise there are Open Source projects whose goal it is to integrate different tools to create a full blown solution for users. The first such projects were Linux distributions, but the current way of d...

presented by Yong Hui Shi

Time machine for backup on PG Cloud

presented by Oleg Bartunov

PostgreSQL is the first relational database which recognized the need of non-atomic data types to support developers of applications from science to Web. Jsonb in Postgres is the attractive feature for modern application developers, who want to work with json documents without sacrificing a strong consistency and ability to use all the power of proven relational technology.

Finally, SQL worl...

presented by Xian Wen Zhu

Oracle migration to PostgreSQL case sharing

presented by Peng Wei Ma

Financial Industry Distributed Database Test Observation

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

presented by Zhang Mei Li

HugeGraph graph database technology and PostgreSQL as its storage

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 high-performance machine because it is set ...

presented by Ibrar Ahmed

PostgreSQL provides a way to communicate with external data sources. This could be another PostgreSQL instance or any other database. The other database might be a relational database such as Clickhouse, MySQL or Oracle; or any NoSQL database such as MongoDB or Hadoop. To achieve this, PostgreSQL implements ISO Standard call SQL-MED in the form of Foreign Data Wrappers (FDW). This presentation ...

presented by Ming Jun Jiang

AsiaInfo AISWare AntDB enables enterprise digitization

presented by Chen Jinbao

The presentation includes the principle of aggregation, the implementation of multi-stage aggregation on greenplum. And how greenplum implement grouping sets. This presentation will delve into how to implement efficient aggregation in a distributed environment, as well as implementations in the query optimizer and executor.

The slides link: https://docs.google.com/presentation/d/1nYiU8-Z2o...

presented by Ahsan Hadi

The future of Postgres Sharding

presented by Peng Li

Dancing with Elephants: Data Security Audit

presented by Yong Ming Wei

PostgreSQL Application in IBM Cognitive Computing and Data Science Services

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

presented by Muhammad Usama and Ahsan Hadi

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 master nodes goes down.

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

presented by Sheng Xi Zhang

PG application practice in e-government industry

presented by Shao Jun Li

GIS - PostgreSQL Applications in SuperMap System

presented by Yang Li

Build Greenplum's low latency data pipeline

presented by John Jeevakumar

We have quite a lot of tools and services available in the market to migrate applications and databases from enterprise databases (like Oracle, SQLServer, Sybase, etc) to open-source databases. However, many a times, these tools do not do the complete code conversion compatible with the target open source. Manual intervention is necessary and the procedures and functions need to be reviewed lin...

presented by Xiu Tang

Oracle Database and Application Migration pg Best Practices

presented by Yun Jiang

PostgreSQL execution plan exploration

presented by Insung Moon and Masahiko Sawada

Transparent data encryption in PostgreSQL and Integration with Key management service

presented by Yi Lin

POLARDB DBA Magic - Performance Insight

presented by Yang Lu

Application of Agricultural Insurance Big Data Technology Based on Postgis

presented by PostgresConf Organizers

The closing session starts from 18:00 in the main hall

presented by Bo Wei and Bin Tian

PG High Availability Training

presented by Xian Wen Zhu

PG Systematic Basic Training Day1

presented by Zheng Zhong Zhou

Deep PostgreSQL 11 System Training Day1

presented by Zheng Zhong Zhou

Deep PostgreSQL 11 System Training Day2

presented by Xian Wen Zhu

PG Systematic Basic Training Day2