Re: directory tree query with big planner variation

From: Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE>
To: Michael Stone <mstone+postgres(at)mathom(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: directory tree query with big planner variation
Date: 2006-07-31 16:19:06
Message-ID: E3048C4B-0D91-48C9-BC37-5B1903C57871@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Am 31.07.2006 um 17:54 schrieb Axel Rau:
>
> Tweaking your query and omitting the RTRIM/REPLACE stuff, I get:
My example did not cover the case of empty subdirectories, in which
case your simplified query fails:
-------------------------------
path | children
------------------------------+----------
.DS_Store | f
/Users/axel/Projects/ADMIN/ | t
/Users/axel/Projects/DB/ | t
/Users/axel/Projects/HW/ | t
/Users/axel/Projects/JETSEC/ | t
/Users/axel/Projects/MISC/ | t
/Users/axel/Projects/NET/ | t
/Users/axel/Projects/SW/ | t
/Users/axel/Projects/TOOLS/ | t
(9 rows)
-------------------------------
Where it shoould be:
-------------------------------
name | children
-----------+----------
.DS_Store | f
ADMIN | t
DB | t
HW | f
JETSEC | f
MISC | f
NET | t
SW | t
TOOLS | t
(9 rows)
-------------------------------
Axel
Axel Rau, ☀Frankfurt , Germany +49-69-951418-0

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Axel Rau 2006-07-31 16:20:56 Re: directory tree query with big planner variation
Previous Message H Hale 2006-07-31 16:09:02 Re: sub select performance due to seq scans