Apache AGE Stress-Tested: How PostgreSQL's Graph Extension Holds Up Under Load

Developers investigating Apache AGE, a graph extension for PostgreSQL, discovered segmentation faults that prompted a broader performance inquiry. Apache AGE allows users to query graph data directly within PostgreSQL using openCypher, eliminating the need for a separate graph database. The extension stores vertices and edges in standard PostgreSQL tables, automatically creating child tables when new node or relationship types are introduced. Researchers found no existing benchmarks or published performance results for Apache AGE, making a from-scratch investigation necessary. The study aimed to assess both the stability and performance characteristics of the extension under stress conditions.