Beijing 2019 Program
![PostgresConf Organizers PostgresConf Organizers](https://secure.gravatar.com/avatar/a7bf2ab1d84e75662e76ecfcbb3bad42.png?r=PG&s=48)
Registration at the reception
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.
13:10 - 13:40 Meeting Room 1 Main![Jian Miao Jian Miao](/system/users/avatar/000/002/811/medium/20-1PQGP302522.jpg)
PostgreSQL Association Meeting
presented by Jian Miao
The general talk about the PG association
14:00 - 14:10 Meeting Room 1 Main![Joshua Drake Joshua Drake](https://secure.gravatar.com/avatar/0158a431184f91128b0f2ec087c7cce5.png?r=PG&s=48)
PostgreSQL internal Meeting
presented by Joshua Drake
Introduce the new International Consultant Committee members
14:10 - 14:20 Meeting Room 1![PostgresConf Organizers PostgresConf Organizers](https://secure.gravatar.com/avatar/a7bf2ab1d84e75662e76ecfcbb3bad42.png?r=PG&s=48)
International Consultant Committee Annual Meeting
presented by PostgresConf Organizers
That's the internal meeting of PostgreSQL Association, International Consultant Committee meeting.
14:20 - 15:40 Meeting Room 1 Main![PostgresConf Organizers PostgresConf Organizers](https://secure.gravatar.com/avatar/a7bf2ab1d84e75662e76ecfcbb3bad42.png?r=PG&s=48)
The internal meeting of the association, except the international committee
presented by PostgresConf Organizers
15:40 - 17:00 Meeting Room 1 Main
![PostgresConf Organizers PostgresConf Organizers](https://secure.gravatar.com/avatar/a7bf2ab1d84e75662e76ecfcbb3bad42.png?r=PG&s=48)
Opening Ceremony
presented by PostgresConf Organizers
Announce the opening of the conference
09:00 - 09:10 Main JINGGE HALL Main![Officer Representative Officer Representative](/system/users/avatar/000/002/810/medium/58ee3d6d55fbb2fb2aa9ad02424a20a44623dc24.png)
Officer representative speech from the government
presented by Officer Representative
Officer representative speech from the government. Emphasize the importance of the Open-source Postgres
09:10 - 09:20 Main JINGGE HALL Main![Guangnan Ni Guangnan Ni](/system/users/avatar/000/002/809/medium/3tl3fy41mli.png)
presented by Guangnan Ni
Speech by Ni Guangnan, member of China Engineering Academy
09:20 - 09:40 Main JINGGE HALL Main![PostgresConf Organizers PostgresConf Organizers](https://secure.gravatar.com/avatar/a7bf2ab1d84e75662e76ecfcbb3bad42.png?r=PG&s=48)
PG Annual Technology Awards Ceremony
presented by PostgresConf Organizers
PG Annual Technology Awards Ceremony To award the PostgreSQL technology best practices in China
09:50 - 10:30 Main JINGGE HALL Main![Joshua D. Drake Joshua D. Drake](/system/users/avatar/000/000/044/medium/headshot_new.png)
Postgres: The World's Database
presented by Joshua D. Drake
The PostgreSQL industry, ecosystem etc
10:30 - 11:10 Main JINGGE HALL Main![Fei Fei Li Fei Fei Li](/system/users/avatar/000/002/812/medium/lifeifei.jpg)
Alibaba Cloud and database topics, and its applications in China
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
11:20 - 12:00 Main JINGGE HALL Main![PostgresConf Organizers PostgresConf Organizers](https://secure.gravatar.com/avatar/a7bf2ab1d84e75662e76ecfcbb3bad42.png?r=PG&s=48)
Lunch Break
presented by PostgresConf Organizers
The lunch break, 50 minutes
12:10 - 12:50 Main JINGGE HALL Main![Xiao Jun Zheng Xiao Jun Zheng](/system/users/avatar/000/002/819/medium/zhengxiaojun.png)
presented by Xiao Jun Zheng
The topic will be update later
13:30 - 14:10 Main JINGGE HALL![Lei Jun Hu Lei Jun Hu](/system/users/avatar/000/002/820/medium/huleijun.png)
presented by Lei Jun Hu
The topic is to be updated
14:10 - 14:50 Main JINGGE HALL Ecological development of PG and PG Commercial![PostgresConf Organizers PostgresConf Organizers](https://secure.gravatar.com/avatar/a7bf2ab1d84e75662e76ecfcbb3bad42.png?r=PG&s=48)
presented by PostgresConf Organizers
Coffee Break
14:50 - 15:10 Main JINGGE HALL![Shao Cong Xiao Shao Cong Xiao](/system/users/avatar/000/002/821/medium/xiaoshaocong.png)
presented by Shao Cong Xiao
Topic details to be updated later
15:10 - 15:50 Main JINGGE HALL![Yang Wang Yang Wang](/system/users/avatar/000/002/822/medium/wangyang.png)
presented by Yang Wang
The topic is to be updated
15:50 - 16:30 Main JINGGE HALL![Wen Sheng Zhang Wen Sheng Zhang](/system/users/avatar/000/002/823/medium/zhangwensheng.png)
presented by Wen Sheng Zhang
The topic is to be updated
16:30 - 17:10 Main JINGGE HALL![Grant Zhou Grant Zhou](/system/users/avatar/000/000/315/medium/2.Grant.jpg)
![Joshua Drake Joshua Drake](https://secure.gravatar.com/avatar/0158a431184f91128b0f2ec087c7cce5.png?r=PG&s=48)
![Oleg Bartunov Oleg Bartunov](/system/users/avatar/000/000/211/medium/15138544_10210421119420599_1841521026585993990_o.jpg)
![Xiao Jun Zheng Xiao Jun Zheng](/system/users/avatar/000/002/819/medium/zhengxiaojun.png)
![Michael Meskes Michael Meskes](/system/users/avatar/000/000/066/medium/michael.jpg)
Dialogue program
presented by Joshua Drake, Oleg Bartunov, Xiao Jun Zheng, Grant Zhou, and Michael Meskes
Traditional Dialogue Program
17:10 - 17:50 Main JINGGE HALL Main![PostgresConf Organizers PostgresConf Organizers](https://secure.gravatar.com/avatar/a7bf2ab1d84e75662e76ecfcbb3bad42.png?r=PG&s=48)
Meet with the community
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.
18:30 - 19:50 Main JINGGE HALL Main![Joshua Drake Joshua Drake](https://secure.gravatar.com/avatar/0158a431184f91128b0f2ec087c7cce5.png?r=PG&s=48)
PostgreSQL 12 New Features
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!
09:00 - 09:40 JINGGE HALL TRACK1 - English Track English Speaker Track![Ning Zhen Li Ning Zhen Li](https://secure.gravatar.com/avatar/e3da33d65b88df5841212fc22dec0a6b.png?r=PG&s=48)
Open source software compliance discussion
presented by Ning Zhen Li
Open source software compliance discussion
09:00 - 09:40 JINGGE HALL TRACK 3 - Ecological development of PG and its commercial Ecological development of PG and PG Commercial![daming shao daming shao](https://secure.gravatar.com/avatar/edbbad8e2ffbe51b08d6660efd9b39ee.png?r=PG&s=48)
presented by daming shao
The kernel analysis of PG parser.
09:00 - 09:40 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![Michael Meskes Michael Meskes](/system/users/avatar/000/000/066/medium/michael.jpg)
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...
more 09:40 - 10:10 JINGGE HALL TRACK1 - English Track English Speaker Track![Yong Hui Shi Yong Hui Shi](https://secure.gravatar.com/avatar/d7474e15a4caf1cf061e76fa63d06c19.png?r=PG&s=48)
Time machine for backup on PG Cloud
presented by Yong Hui Shi
Time machine for backup on PG Cloud
09:40 - 10:20 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![Oleg Bartunov Oleg Bartunov](/system/users/avatar/000/000/211/medium/15138544_10210421119420599_1841521026585993990_o.jpg)
a query language for json
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...
more 10:10 - 10:50 JINGGE HALL TRACK1 - English Track English Speaker Track![Xian Wen Zhu Xian Wen Zhu](https://secure.gravatar.com/avatar/92374d47ac40fce69c045f372190edd9.png?r=PG&s=48)
Oracle migration to PostgreSQL case sharing
presented by Xian Wen Zhu
Oracle migration to PostgreSQL case sharing
10:30 - 11:10 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![Peng Wei Ma Peng Wei Ma](https://secure.gravatar.com/avatar/26ecdd6ebf9ea89887710c805f7ef9bc.png?r=PG&s=48)
Financial Industry Distributed Database Test Observation
presented by Peng Wei Ma
Financial Industry Distributed Database Test Observation
10:30 - 11:10 JINGGE HALL TRACK 3 - Ecological development of PG and its commercial Ecological development of PG and PG Commercial![Ibrar Ahmed Ibrar Ahmed](/system/users/avatar/000/001/983/medium/Untitled_auto_x2.jpg)
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...
more 10:50 - 11:30 JINGGE HALL TRACK1 - English Track English Speaker Track![Zhang Mei Li Zhang Mei Li](https://secure.gravatar.com/avatar/ffa6a683a40f961acf944a1f1f21287b.png?r=PG&s=48)
HugeGraph graph database technology and PostgreSQL as its storage
presented by Zhang Mei Li
HugeGraph graph database technology and PostgreSQL as its storage
11:10 - 11:50 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![Ibrar Ahmed Ibrar Ahmed](/system/users/avatar/000/001/983/medium/Untitled_auto_x2.jpg)
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 ...
more 11:20 - 12:00 JINGGE HALL TRACK1 - English Track English Speaker Track![Ibrar Ahmed Ibrar Ahmed](/system/users/avatar/000/001/983/medium/Untitled_auto_x2.jpg)
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 ...
more 11:50 - 12:30 JINGGE HALL TRACK1 - English Track English Speaker Track![Ming Jun Jiang Ming Jun Jiang](https://secure.gravatar.com/avatar/b2ed26378613d46b6d8234e1311f7aeb.png?r=PG&s=48)
AsiaInfo AISWare AntDB enables enterprise digitization
presented by Ming Jun Jiang
AsiaInfo AISWare AntDB enables enterprise digitization
13:30 - 14:10 JINGGE HALL TRACK 3 - Ecological development of PG and its commercial Ecological development of PG and PG Commercial![Chen Jinbao Chen Jinbao](/system/users/avatar/000/001/070/medium/__.png)
distribute aggregation
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...
more 13:30 - 14:10 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![Ahsan Hadi Ahsan Hadi](/system/users/avatar/000/002/377/medium/ahsan-headshot.jpg)
The future of Postgres Sharding
presented by Ahsan Hadi
The future of Postgres Sharding
13:40 - 14:20 JINGGE HALL TRACK1 - English Track English Speaker Track![Peng Li Peng Li](https://secure.gravatar.com/avatar/1fbc2b21dda4fd68f9381c5b2d1bdb5b.png?r=PG&s=48)
Dancing with Elephants: Data Security Audit
presented by Peng Li
Dancing with Elephants: Data Security Audit
14:10 - 14:50 JINGGE HALL TRACK 3 - Ecological development of PG and its commercial Ecological development of PG and PG Commercial![Yong Ming Wei Yong Ming Wei](https://secure.gravatar.com/avatar/22d325c67675a22929ed6fe647e6d9c7.png?r=PG&s=48)
PostgreSQL Application in IBM Cognitive Computing and Data Science Services
presented by Yong Ming Wei
PostgreSQL Application in IBM Cognitive Computing and Data Science Services
14:10 - 14:50 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![Asif Rehman Asif Rehman](https://secure.gravatar.com/avatar/2ff7c61439c511228371e55b337c2904.png?r=PG&s=48)
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 q...
more 14:20 - 15:00 JINGGE HALL TRACK1 - English Track English Speaker Track![Muhammad Usama Muhammad Usama](https://secure.gravatar.com/avatar/375c28070fc47d17c1bae8ad5396c8e0.png?r=PG&s=48)
![Ahsan Hadi Ahsan Hadi](/system/users/avatar/000/002/377/medium/ahsan-headshot.jpg)
PostgreSQL HA
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...
more 14:50 - 15:30 JINGGE HALL TRACK1 - English Track English Speaker Track![Sheng Xi Zhang Sheng Xi Zhang](https://secure.gravatar.com/avatar/bfa1a32cd60076eb853a435b38d9f29e.png?r=PG&s=48)
PG application practice in e-government industry
presented by Sheng Xi Zhang
PG application practice in e-government industry
14:50 - 15:30 JINGGE HALL TRACK 3 - Ecological development of PG and its commercial Ecological development of PG and PG Commercial![Shao Jun Li Shao Jun Li](https://secure.gravatar.com/avatar/bace45b50ea10190cb35c523a4ca9e5b.png?r=PG&s=48)
GIS - PostgreSQL Applications in SuperMap System
presented by Shao Jun Li
GIS - PostgreSQL Applications in SuperMap System
14:50 - 15:30 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![Yang Li Yang Li](https://secure.gravatar.com/avatar/ef3c20fa6899f1d75157b3f602b5480a.png?r=PG&s=48)
Build Greenplum's low latency data pipeline
presented by Yang Li
Build Greenplum's low latency data pipeline
15:40 - 16:20 JINGGE HALL TRACK 3 - Ecological development of PG and its commercial Ecological development of PG and PG Commercial![John Jeevakumar John Jeevakumar](https://secure.gravatar.com/avatar/31b0f08a723a5ca7a4f3e3c736b0258d.png?r=PG&s=48)
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...
more 15:40 - 16:20 JINGGE HALL TRACK1 - English Track English Speaker Track![Xiu Tang Xiu Tang](https://secure.gravatar.com/avatar/e8ae45fa6bedcef0c23761f31e04d095.png?r=PG&s=48)
Oracle Database and Application Migration pg Best Practices
presented by Xiu Tang
Oracle Database and Application Migration pg Best Practices
15:40 - 16:20 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![Yun Jiang Yun Jiang](https://secure.gravatar.com/avatar/44b723cc9c4a12d9c992fefb1f5a8a8f.png?r=PG&s=48)
PostgreSQL execution plan exploration
presented by Yun Jiang
PostgreSQL execution plan exploration
16:20 - 17:00 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![Insung Moon Insung Moon](/system/users/avatar/000/002/837/medium/profile_moon-233x300.jpg)
![Masahiko Sawada Masahiko Sawada](https://secure.gravatar.com/avatar/be5a785531890abfcb0e4776582c13bc.png?r=PG&s=48)
Transparent data encryption in PostgreSQL and Integration with Key management service
presented by Insung Moon and Masahiko Sawada
Transparent data encryption in PostgreSQL and Integration with Key management service
16:30 - 17:10 JINGGE HALL TRACK1 - English Track English Speaker Track![Yi Lin Yi Lin](https://secure.gravatar.com/avatar/4c2a44f796c2678976a16c7c980fb2fe.png?r=PG&s=48)
POLARDB DBA Magic - Performance Insight
presented by Yi Lin
POLARDB DBA Magic - Performance Insight
16:50 - 17:30 JINGGE HALL TRACK 3 - Ecological development of PG and its commercial Ecological development of PG and PG Commercial![Yang Lu Yang Lu](https://secure.gravatar.com/avatar/e8320cce9753352f1bb355bb1eb0da4d.png?r=PG&s=48)
Application of Agricultural Insurance Big Data Technology Based on Postgis
presented by Yang Lu
Application of Agricultural Insurance Big Data Technology Based on Postgis
17:00 - 17:40 JINGGE HALL TRACK 2 - PG Best Practices PostgreSQL Best Practices![PostgresConf Organizers PostgresConf Organizers](https://secure.gravatar.com/avatar/a7bf2ab1d84e75662e76ecfcbb3bad42.png?r=PG&s=48)
Closing sessions
presented by PostgresConf Organizers
The closing session starts from 18:00 in the main hall
18:00 - 18:30 JINGGE HALL TRACK 3 - Ecological development of PG and its commercial![Bo Wei Bo Wei](https://secure.gravatar.com/avatar/332add45806830d01ab1d0d3c970df8d.png?r=PG&s=48)
![Bin Tian Bin Tian](https://secure.gravatar.com/avatar/eb7a0560a599c7911570ca2c2615952b.png?r=PG&s=48)
PG High Availability Training
presented by Bo Wei and Bin Tian
PG High Availability Training
09:00 - 19:00 TRAINING ROOM C TRAINING![Xian Wen Zhu Xian Wen Zhu](https://secure.gravatar.com/avatar/92374d47ac40fce69c045f372190edd9.png?r=PG&s=48)
PG Systematic Basic Training Day1
presented by Xian Wen Zhu
PG Systematic Basic Training Day1
09:00 - 19:00 TRAINING ROOM B TRAINING![Zheng Zhong Zhou Zheng Zhong Zhou](/system/users/avatar/000/002/841/medium/425189_20181120085732321.png)
Deep PostgreSQL 11 System Training Day1
presented by Zheng Zhong Zhou
Deep PostgreSQL 11 System Training Day1
09:00 - 19:00 TRAINING ROOM A TRAINING![Zheng Zhong Zhou Zheng Zhong Zhou](/system/users/avatar/000/002/841/medium/425189_20181120085732321.png)
Deep PostgreSQL 11 System Training Day2
presented by Zheng Zhong Zhou
Deep PostgreSQL 11 System Training Day2
09:00 - 19:00 TRAINING ROOM A TRAINING![Xian Wen Zhu Xian Wen Zhu](https://secure.gravatar.com/avatar/92374d47ac40fce69c045f372190edd9.png?r=PG&s=48)
PG Systematic Basic Training Day2
presented by Xian Wen Zhu
PG Systematic Basic Training Day2
09:00 - 19:00 TRAINING ROOM B TRAININGpresented by Denis Magda
Learn how to boost performance 10x and scale to over million transactions per second with in-memory computing.
It will be shown how to add speed and scale to your PostgresQL-based applications, APIs and analytics for different use cases. We will discuss when each option makes sense, as well as how to evolve your architecture over time to add the speed, scale, agility and new technologies nee...
more English Speaker Track