n this talk, we will delve into the complexities of maintaining support for multiple versions of PostgreSQL within the Citus extension. Citus is a powerful extension of PostgreSQL that is designed to be compatible with the last 2-3 major versions of the database management system. However, this is no easy feat and requires a significant amount of effort to ensure that Citus remains an updated extension rather than a fork.
We will also share insights on the bugs that we encountered while working with PostgreSQL 15 and the strategies we employed to overcome integration issues during the beta and release candidate stages. This talk will provide a behind-the-scenes look at the challenges of keeping Citus up-to-date and provide practical tips for managing similar issues in other PostgreSQL extensions.