PostgresConf is the world's largest PostgreSQL conference series, and it is now in China. China PostgreSQL Branch and the PostgresConf organization in the United States, in 2019, has successfully held two major domestic PG ecological conferences - PostgreSQL Open officially entered the international PostgresConf conference sequence this year, and officially changed its name to PostgresConf.CHN. The conference was jointly organized by China OSS Promotion Union(COPU), China PostgreSQL Association, China PostgreSQL Community and PGCentral Foundation. The organization of PostgresConf CHN will further strengthen and strengthen the territory of the PostgresConf global series of conferences and promote the integration of Chinese PG forces into the global PG ecosystem.
Some of our speakers
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,...
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 up to use all available resources. PostgreSQL provides mechanisms that allow you to tune your...
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 quite a many replication options with each having its own pros and cons. In this talk I will try to...
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-Z2omzmeYJvh1EznAPk-KnMfXZNIrBbt2JICfo/edit?usp=sharing
Officer representative speech from the government. Emphasize the importance of the Open-source Postgres
Jul 05 JSON PATH
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 world has recognized the NoSQL and released the new SQL-2016 standard, which includes specification of...
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 comes in, the core feature of Pgpool-II provides HA by eliminating the SPOF is the Watchdog. This...
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 needed for digital transformation and other initiatives. By the end of this session, you will...
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 line by line and rewritten to provide the same functionality. If database migration is done right,...
has the most awesome program ever!
See rock-star speakers cover the topics of
English Speaker Track
JSON PATH by Oleg Bartunov
The future of Postgres Sharding by Ahsan Hadi
PostgreSQL 12 New Features by Joshua Drake
All about PostgreSQL Replication by Asif Rehman
Tune your Linux Box, not just PostgreSQL by Ibrar Ahmed
A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed
Open Source - The Next Step by Michael Meskes
Alibaba Cloud & Database by Fei Fei Li
Lunch Break by PostgresConf Organizers
Dialogue program by Grant Zhou
PostgreSQL industry and PostgreSQL conferences by Joshua D. Drake
PG Annual Technology Awards Ceremony by PostgresConf Organizers
PostgresConf Beijing Opening Ceremony by PostgresConf Organizers
Speech by the officer of the Ministry of Industry and Information Technology by Officer Representative
PostgreSQL Association Meeting by Jian Miao
Open Source Topic by Guangnan Ni
Registration by PostgresConf Organizers
PostgreSQL Best Practices
Implementation of distributed aggregation in Greenplum by Chen Jinbao
PostgreSQL execution plan exploration by Yun Jiang
GIS - PostgreSQL Applications in SuperMap System by Shao Jun Li
Time machine for backup on PG Cloud by Yong Hui Shi
Oracle migration to PostgreSQL case sharing by Xian Wen Zhu
Kernel Analysis of PostgreSQL Parser by daming shao
Ecological development of PG and PG Commercial
POLARDB DBA Magic - Performance Insight by Yi Lin
Build Greenplum's low latency data pipeline by Yang Li
Dancing with Elephants: Data Security Audit by Peng Li
Financial Industry Distributed Database Test Observation by Peng Wei Ma
Open source software compliance discussion by Ning Zhen Li
PG application practice in e-government industry by Sheng Xi Zhang
AsiaInfo AISWare AntDB enables enterprise digitization by Ming Jun Jiang
PostgreSQL in Inspur by Lei Jun Hu