{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Hacking Postgres","title":"S2E7: Bharath Rupireddy, AWS","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/a8f30775\"></iframe>","width":"100%","height":180,"duration":1808,"description":"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 featurePostgres 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 replicationThe complexities of conflict resolutionUsing PostgreSQL 16 in production scenarios for active-active replicationThe role of databases evolving within different industriesLinks mentioned:¡Databases! – A Database Seminar SeriesHacking Postgres, Ep. 9: Bertrand DrouvotPGConf IndiaHyderabad PostgreSQL User GroupPGConf.devBharath on LinkedInBharath on X (@BRupireddy)Bharath on Github","thumbnail_url":"https://img.transistorcdn.com/oGfVGIPo6SkWpg3fyQ1pTr_0mERXMTLBZaW8YDxHoG0/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzQ1NjA5LzE2OTU5/NDUwOTgtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}