Skip site navigation (1) Skip section navigation (2)

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: 2006-07-31 11:15:42
Message-ID: 20060731111540.GE2900@mathom.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Axel RauDate: 2006-07-31 11:54:24
Subject: Re: directory tree query with big planner variation
Previous:From: Axel RauDate: 2006-07-31 10:48:11
Subject: directory tree query with big planner variation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group