Am 31.07.2006 um 15:53 schrieb Mark Lewis:
> It seems like you might be able to avoid the expensive directory
> entirely without changing the schema by defining an immutable function
> dir_depth(path), which would just count the number of forward slashes.
> Then create a functional index on dir_depth(path) and in the query
> do a
> check for directories with a given prefix and the expected dir_depth.
Still I must check for flatfiles in those subdirectories...
See my clarification here
Axel Rau, ☀Frankfurt , Germany +49-69-951418-0
In response to
pgsql-performance by date
|Next:||From: Arjen van der Meijden||Date: 2006-07-31 16:30:27|
|Subject: Re: Performances with new Intel Core* processors|
|Previous:||From: Axel Rau||Date: 2006-07-31 16:19:06|
|Subject: Re: directory tree query with big planner variation|