Bharath Rupireddy has carved a niche for himself in the Postgres community since he began using the database system back in 2020. From his start at EnterpriseDB to making strides at Microsoft, and now contributing to the AWS open-source project, Bharath is entrenched in the inner workings of Postgres development. He has worked in many areas of Postgres such as WAL, Replication, pg_walinspect extension, bug fixes, performance improvements, new SQL functions etc.
In this episode we explore:
- Starting with Postgres in 2020 and learning the basics while contributing to Parallel COPY feature
- Postgres recent features such as pg_walinspect extension, WAL source switch from archive to streaming, WAL insertion lock improvements, WAL read from buffers, more replication slot invalidation mechanisms like XID age based and inactive_timeout based ones, new table access methods for multi inserts.
- The future of native active-active replication
- The complexities of conflict resolution
- Using PostgreSQL 16 in production scenarios for active-active replication
- The role of databases evolving within different industries
Links mentioned:
What is Hacking Postgres?
All about extensions, extension creators, and people doing cool things with Postgres. New episodes every week.