On Mon, Jul 31, 2006 at 12:48:11PM +0200, Axel Rau wrote:
> WHERE P.path ~ '^%@/[^/]*/$' ) AS NLPC
This can't be indexed. You might try something like
WHERE P.path LIKE '%(at)%' AND P.path ~ '^%@/[^/]*/$'
The schema could be a lot more intelligent here. (E.g., store path
seperately from file/directory name, store type (file or directory)
seperately, etc.) Without improving the schema I don't think this will
ever be a speed demon.
In response to
pgsql-performance by date
|Next:||From: Axel Rau||Date: 2006-07-31 11:54:24|
|Subject: Re: directory tree query with big planner variation|
|Previous:||From: Axel Rau||Date: 2006-07-31 10:48:11|
|Subject: directory tree query with big planner variation|