Re:Recursive Postgres Queries
by ibotty on Monday June 24, 2013 @01:54PM
(#5934531)
nested sets are not generally faster. for anything which is not "get all direct and indirect children", they are slower than common table expressions (recursive queries). in databases supporting cte's, that is.
Did they look at http://www.ibase.ru/devinfo/DBMSTrees/sqltrees.html and see if it can be adapted to their problem?