PostgreSQL.Live Born in the world, dare to subvert

Time:2020-10-13

This is the future of open source technology

This brings together Chinese and foreign big names to share core technologies

Here, let’s talk about mainstream topics and exchange top technologies

In this way, we will work together with top enterprises for win-win cooperation

PostgreSQL.Live brief introduction
PostgreSQL.Live Jointly prepared by China PostgreSQL branch and PostgreSQL international community, and participated by well-known PostgreSQL ecological chain enterprises, the live salon will be open to global developers, architects, PostgreSQL users and enthusiasts free of charge in the way of online live broadcast and on-demand learning; at the same time, there will be one-to-one experts on the cable, face-to-face technical team, etc.

PostgreSQL.Live Cloud Technology Salon

Phase 1: future PostgreSQL fragmentation
Speaker: Bruce Momjian

Introduction:
Bruce Momjian is a co-founder and core team member of PostgreSQL’s global development team, and is the author of “Introduction and concepts of PostgreSQL” published by ad dison Wesley. Bruce Momjian has been employed by enterprisedb since 2006 and is currently the vice president of enterprisedb.

Theme sharing:
This paper discusses the advantages of slicing and the requirements of future implementation of PostgreSQL partitioning.

Click the link below for details

Future PostgreSQL fragmentation

Phase 2: table partitioning in Postgres
Speaker: Amit langote

Introduction:
Amit langote is one of the leading developers of the PostgreSQL community from enterprisedb Japan. He has contributed a lot to the development of major features in recent PostgreSQL versions, such as table partitioning and command progress reporting.

Theme sharing:
Table partitioning is an important tool for developers and DBAs to deal with large and growing database tables. Postgres has long allowed users to partition tables in their databases, but it was not until Postgres 10, which adopted a new DDL syntax for partitioned tables, to do so. Postgres11, 12 and soon to be released 13 have made great progress to make partitions available in terms of function and performance, so that users can seriously consider partitions in production.

Click the link below for details

Table partition in Postgres

Phase 3: query routing technology using pgpool-ii
Speaker: Ishii Tatsuo

Introduction:
He is the founder of PG user association in Japan and the original author of pg-pool-ii. As a core member of the PostgreSQL international community, he has been involved. Mr. Ishii currently works in SRA OSS, Inc. in Japan. In addition to his work, he enjoys reading science fiction, including Liu Cixin’s “three bodies.”.

Theme sharing:
PostgreSQL supports stream replication clusters and is widely used. However, it depends on whether the user routes read or write queries to the primary or standby server. For example, notifications are not allowed in standby servers, but they are allowed in read-only transactions. Pgpool-ii can help you by providing flexible policies to route user queries without having to understand in detail the limitations of alternate servers.

Click the link below for details

Query routing technology using pgpool-ii

For more wonderful content, please pay attention to the following platforms and websites:

Official account of China Postgre SQL chapter (technical articles and technical activities):

PostgreSQL branch of Open Source Software Alliance

China postgre SQL branch technical Q & a community:

http://www.pgfans.cn

Official website of China postgre SQL branch:

http://www.postgresqlchina.com