Supercharging PostgreSQL Extensibility - Alexander Korotkov

Показать описание

PostgreSQL introduced the concept of the Table Access Method API in version 12. Originally intended as a "storage plugin framework", this API was intended to allow additional and new PostgreSQL storage engines which could cover more potential use cases that are optimized for different hardware architectures and different data models.
The current design of the API implies a new engine will re-use pretty much of the existing PostgreSQL internals including buffer manager, block-level WAL, tuple identifiers, transaction identifiers, and enumerated snapshots. However, these internals cause many shortcomings by themselves such as sub-optimal multi-core scalability, significantly increased WAL traffic, etc.
Is it possible to grow beyond these architectural limitations? How difficult is it? What does a potential cloud-native Postgres look like?
This talk will discuss a small set of proposed patches that brings table access method API to a new level of power and flexibility. This "patchset" allows implementing anti-buffering instead of buffer mapping, row-level WAL instead of block-level WAL, arbitrary row identifiers in index-organized tables, scalable CSN snapshots, and so on.

🗣️ 𝗔𝗯𝗼𝘂𝘁 𝗦𝗽𝗲𝗮𝗸𝗲𝗿
Alexander Korotkov is a PostgreSQL Major Contributor & Committer, and Ph.D. in computer science. He contributed to many fields of PostgreSQL including indexing, statistics, concurrency, extensibility, and more. In 2015 Alexander co-founded and became the technical chief and development officer at Postgres Professional. He is the inventor behind OrioleDB which seeks to deliver the solutions to PostgreSQL wicked problems.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introduction
⏱ 0:31 ⇒ Supercharging PostgreSQL Extensibility
⏱ 17:49 ⇒ Question: Do you think alternative database engines create a risk of fragmentation for PostgreSQL development?

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we are dedicated to serving developers worldwide, enabling them to build exceptional data-driven products that measure everything that matters. Analyzing this data across the time dimension ("time-series data") enables developers to understand what is happening right now, how that is changing, and why that is changing. We are backed by top-tier investors with a track record of success in the industry.

💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!