pg-uses-jsonb-with-gin-for-dependent-queries

Summary

The PostgreSQL backend uses JSONB columns with GIN indexes to efficiently look up which beliefs depend on a given node, querying only the relevant relationships rather than loading the entire belief network into memory. This means dependent lookups and retraction cascades scale with the number of affected nodes rather than the total network size, which is a key architectural difference from the SQLite backend.