1.0 link Rainbow Dash Network http://rainbowdash.net/ Toksyuryel (toksyuryel) http://rainbowdash.net/toksyuryel http://rainbowdash.net/notice/1379076 Pre-caching the path instead of generating it dynamically seems to only improve cached performance (though the improvement there is dramatic). In some cases the uncached performance was actually *worse* than generating the path in a WITH RECURSIVE block. <a href="http://pgsql.privatepaste.com/60741d539f" title="http://pgsql.privatepaste.com/60741d539f" rel="nofollow external">http://pgsql.privatepaste.com/60741d539f</a> @<span class="vcard"><a href="http://rainbowdash.net/user/10428" class="url" title="Bit Shift"><span class="fn nickname">bitshift</span></a></span> @<span class="vcard"><a href="http://rainbowdash.net/user/2959" class="url" title="The Pony Formerly Known As Ponydude"><span class="fn nickname">widget</span></a></span> !<span class="vcard"><a href="http://rainbowdash.net/group/878/id" class="url" title="Coder Ponies! (coderpony)"><span class="fn nickname">coderpony</span></a></span> #<span class="tag"><a href="http://rainbowdash.net/tag/sql" rel="tag">SQL</a></span>