Memory safety for Postgres extensions in C/C++

ClickHouse shared engineering insights on managing memory safety when building PostgreSQL extensions in C++. The post details how PostgreSQL's exception-handling and MemoryContext systems conflict with C++ constructors, destructors, and standard allocations. It outlines how ClickHouse solved these challenges across four extensions, including rewriting libraries in plain C to ensure safety.