The Organizing Committee of PostgreSQL Asia Conference 2020 specially launched alicloud databaseGuest series online interviewIn the third phase, we invited fan Zhihui, an alicloud database technology expert. He will bring “unqiuekey: query rewriting enhancement makes your SQL run faster” during 10:20-11:00 of Alibaba cloud database training session on November 17.
Fan Zhihui, alicloud database technology expert
Q1: can you introduce yourself briefly? How do you interact with the PostgreSQL community?
Fan ZhihuiHello, my name is fan Zhihui. I started to contact Oracle database in 2007. Before 2010, I had read most of the Oracle documents and did a lot of tests. But the real contact with PostgreSQL is in 2019. Compared with Oracle, the two biggest differences of PostgreSQL are that PostgreSQL is open source and has a very friendly community. It’s also a challenging thing to participate in community discussion. It’s a series of tests about communication skills, mentality, etc. Finally, even if you have done everything you can (including good code, documents, patch splitting, communication language, etc.), there are many times when you have to wait for a long time, because the resources of the community are too short.
Q2: when did you first contact PostgreSQL? How to embark on the road of product development?
Fan Zhihui: I had more than 10 years of Oracle experience before I came into contact with postgressql. Joining the PostgreSQL R & D team is a process of passive selection. In the first month, I just met the battle of a large Internet of things enterprise. In this battle, I found some room for improvement in the optimizer level of PostgreSQL. This is also quite consistent with my past experience, and then I firmly followed this path.
Q3: have you participated in the iteration of PG version function? What are the main contributions?
Fan Zhihui: I will participate in the iteration of the open source community. At present, our own patch has the identification and application of unique key. The patch is in the review state, and is still under development, including the append node’s perception of runtime partition prune. In addition to submitting patches, there are also reviews of other people’s patches and a lot of discussion.
Q4: how do you usually solve the difficulties in product planning or product development? What do you feel most proud (interesting)?
Fan ZhihuiI usually encourage myself. For example, I will talk to myself, “Hi Andy, can you make a clear understanding about X in 8 hours? Ofcourse, let’s see!”. The key point of this dialogue is a clear description of the problem. There will be a lot of further description of the problem. With a time limit, the mental state will be very good. Of course, such a good state is also available every day.
Alibaba cloud database special session of 2020 PostgreSQL Asia Conference
On November 17, 2020, from morning to evening, eight lecturers from the original factory will share their dry goods and live broadcast in Chinese online PostgresConf.CN & PGConf.Asia Alicloud database special channel of 2020 conference, looking forward to your joining!
About alicloud database
Alibaba cloud intelligent database products division carries all the online data and data services of Alibaba cloud and Alibaba group. It provides a full stack of database products and services from online transaction processing to online analysis and processing, and supports flexible deployment in various environments of public cloud and private cloud, and full coverage of individual developers, small and medium-sized enterprises and global large-scale enterprises. Alibaba cloud database service is the most reliable and efficient choice for both individual and enterprise business requirements. With the advent of the data age, Alibaba cloud database products are redesigned and implemented based on the architecture of cloud computing and data center. It is a global leader in database storage engine, cloud native technology, analysis engine, distributed processing, FPGA / GPU hardware acceleration, intelligent database, intelligent management and control platform, security database and other aspects. It is a comprehensive cloud product and service group Together, we have provided rich database product solutions and industry experience for Alibaba cloud customers and Alibaba Group’s diversified business.
At present, after more than ten years of application practice and technical iteration, Alibaba cloud has the most powerful and rich cloud database product family in China, covering five major sectors: relational database, non relational database, analytical database, database ecological tools and cloud database exclusive cluster, which can meet different database application development needs of users and solve the cloud of enterprise core business The key challenges of the project.
The core products include: self-developed cloud native relational database polardb, cloud native data warehouse analytical dB and cloud native data Lake analysis DLA, cloud native multi-mode database lindorm, cloud database exclusive cluster MyBase and relational database service RDS, non relational database service NoSQL products HBase, redis, mongodb, graphdb, and database ecological tools DTS / DMS / DBS / Adam Operation and maintenance platform DAS, etc.
Among them, polardb is the first cloud native relational database in China, which adopts the separation of storage and computing and the integrated design of software and hardware to meet the needs of large-scale application scenarios.
PostgreSQL Alibaba cloud database special session – nail communication group
about PostgresConf.CN&PGConf . asia2020 Conference
As the largest and most famous PG series conference in the world, pgconf is running in all regions of the world from New York to Moscow, from Rio de Janeiro to Johannesburg. The largest PG technology event in Asia – PGConf.Asia The conference will be held in China for the first time in November this year. As the host, PG branch of China Open Source Software Alliance hosted the conference, which was broadcast to the world through motianlun community. This conference will gather Chinese PG strength, major PG contributors and application enterprises in Asia to jointly build the largest PG ecological conference in Asia.
current PGConf.Asia The conference will PostgresConf.CN The conference was jointly held in China. PostgresConf.CN The China conference is also a global formal conference listed in the postgresconf conference sequence, and also the largest and highest specification PG ecological conference in China. Since 2017, it has been held for three consecutive sessions. This year’s conference will continue to be based on the domestic PG industry, providing the most clear and unique perspective for the audience.
Partner of live broadcast platform
For more wonderful content, please pay attention to the following platforms and websites:
Official account of China PostgreSQL branch (technical articles and technical activities):
PostgreSQL branch of Open Source Software Alliance
China PostgreSQL technical Q & a community:
Official website of China PostgreSQL branch: