Re:Postgres: The Graph Database You Didn't Know You Had
by cryptonector on Friday March 31, 2023 @04:16PM
(#35392952)
Cycles are not a problem: just use `UNION`, not `UNION ALL`.
I myself build transitive closure tables that I update incrementally as needed (sometimes in a deferred way), so that many of the recursive queries I do can be very fast, but I only build transitive closures for the smallest portion I can (basically group nesting).
I myself build transitive closure tables that I update incrementally as needed (sometimes in a deferred way), so that many of the recursive queries I do can be very fast, but I only build transitive closures for the smallest portion I can (basically group nesting).