Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: directory tree query with big planner variation
- From: Michael Stone <mstone+postgres(at)mathom(dot)us>
- To: Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: directory tree query with big planner variation
- Date: Mon, 31 Jul 2006 07:15:42 -0400
- Message-id: <20060731111540.GE2900@mathom.us> <text/plain>
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.
Mike Stone
- Follow-Ups:
- Re: directory tree query with big planner variation
- From: Axel Rau
- Re: directory tree query with big planner variation
- References:
- directory tree query with big planner variation
- From: Axel Rau
- directory tree query with big planner variation
- Prev by Date: directory tree query with big planner variation
- Next by Date: Re: directory tree query with big planner variation
- Previous by thread: directory tree query with big planner variation
- Next by thread: Re: directory tree query with big planner variation
- Indexes: