Decoupling our alignment assumptions about int64 and double #162
Description
--- As of 2026-02-10T22:23:03.000Z ---
Aditya Kamath from IBM successfully tested Tom Lane's POC patch addressing AIX alignment issues with int64 and double types. The patch enables proper handling of DOUBLE PRECISION and BIGINT columns during pg_upgrade operations. Testing involved upgrading from PostgreSQL 15 to master branch on AIX, with all data preserved correctly after upgrade. Both GNU build and Meson test suites passed successfully. Tom Lane provided a refined version of the patch, propagating BEGIN/END_CATALOG_STRUCT macros across all catalog headers and implementing push/pop pragma variants for better future compatibility. Thomas Munro noted that IBM has moved away from xlc compiler support, suggesting the new IBM OpenXL C/C++ compiler based on LLVM/Clang might handle these alignment issues better. Tom Lane expressed interest in testing the new toolchain once the gcc-based port is complete.
IBM的Aditya Kamath成功测试了Tom Lane的POC补丁，该补丁解决了AIX上int64和double类型的对齐问题。该补丁能够在pg_upgrade操作期间正确处理DOUBLE PRECISION和BIGINT列。测试涉及在AIX上从PostgreSQL 15升级到master分支，升级后所有数据都得到正确保留。GNU构建和Meson测试套件都成功通过。Tom Lane提供了补丁的改进版本，将BEGIN/END_CATALOG_STRUCT宏传播到所有目录头文件中，并实现了push/pop pragma变体以提供更好的未来兼容性。Thomas Munro指出IBM已经不再支持xlc编译器，建议基于LLVM/Clang的新IBM OpenXL C/C++编译器可能能更好地处理这些对齐问题。Tom Lane表示一旦基于gcc的移植完成，有兴趣测试新的工具链。
participants - 参与者: