News for hackers. Stuff that matters.
Re:Recursive Postgres Queries by btilly on Monday June 24, 2013 @12:27PM (#5933958)
This is basically a tree like data structure.

Did they look at http://www.ibase.ru/devinfo/DBMSTrees/sqltrees.html and see if it can be adapted to their problem?

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.