Postgres Pro
Downloads
Home   >   mailing lists

Re: directory tree query with big planner variation - Mailing list pgsql-performance

From Axel Rau
Subject Re: directory tree query with big planner variation
Date
Msg-id E3048C4B-0D91-48C9-BC37-5B1903C57871@Chaos1.DE
Whole thread Raw
In response to Re: directory tree query with big planner variation  (Axel Rau <Axel.Rau@Chaos1.DE>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: H Hale
Date:
Subject: Re: sub select performance due to seq scans
Next
From: Axel Rau
Date:
Subject: Re: directory tree query with big planner variation