Thanks, Jinbao, for starting this discussion and investigating the feasibility of upgrading to PostgreSQL 18. I agree that staying aligned with PostgreSQL upstream is important for Cloudberry in the long run, and I believe upgrading to PG18 is something we should eventually do.
However, I don't think now is the best time for another major kernel upgrade. We have only recently completed the PG16 upgrade, and there is still some follow-up work to finish. There are several remaining FIXME items and review PRs, and we also discovered that some commits were unintentionally dropped during the migration (for example, #1826). Some tests are unstable, so it is also worth exploring the root cause to see if the kernel needs improvements. I think it's worth completing these tasks and reviewing them before moving on. In addition, our ecosystem projects, such as cloudberry-backup and cloudberry-pxf, are still in the process of adapting to and validating against PG16. This work will take time, and having a stable and well-supported PG16 foundation is important for both users and contributors. I also agree with Jiaqi that improving stability, planner, streaming, and other user-facing capabilities should remain our near-term priorities. The good news is that the investigation suggests upgrading to PG18 may be much easier than we previously expected. That gives us more flexibility—we can first finish the remaining PG16 work, strengthen the ecosystem, and then move to PG18 on a more solid foundation. Thanks, Dianjin On 2026/07/06 04:53:09 Jinbao Chen wrote: > Dear Cloudberry Community, > I hope this email finds you well. > I would like to propose upgrading the Cloudberry core from PostgreSQL 16 to > version 18. > The primary goal of this upgrade is to closely align Cloudberry with the > upstream development lifecycle. By keeping our core in sync, we will not > only strengthen our ties with the PostgreSQL ecosystem but also streamline > the workflow for Cloudberry developers to contribute code back to the > PostgreSQL community. > As you may know, PostgreSQL 17 and 18 introduce numerous groundbreaking > performance features, including: > > - Asynchronous I/O > - Parallel log processing > > These enhancements hold immense value and represent milestone improvements > for Cloudberry's capabilities. > Furthermore, following a detailed preliminary investigation and research > phase, I am confident that we can accomplish this kernel upgrade within a > much shorter timeframe than initially anticipated. > I would love to gather your thoughts on this proposal. > Looking forward to your feedback. > Best regards, > Jinbao Chen > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
