3 ms·
In my experience Postgres works really with a Recursive CTE inside a Materialized View for Graphs. Latest version can detect cycles. I used to add a distance co
by garyclarke27 4y ago
In my experience Postgres works really with a Recursive CTE inside a Materialized View for Graphs. Latest version can detect cycles. I used to add a distance column as well, to show number of hops apart, any 2 nodes are.
Hoping Postgres adds Automatic Incremental Mat View Maintenance soon, it will be perfect then as a Graph Database.
- TOMDM 4y agoIncremental materialised view maintenance is a killer feature. If Postgres added it, almost all of my interest in Materialize (the database, not the technique) would vanish immediately.