Re: Implementing an regex filter - Mailing list pgsql-sql

From Paul Lambert
Subject Re: Implementing an regex filter
Date
Msg-id 46BA400F.2080704@autoledgers.com.au
Whole thread Raw
In response to Implementing an regex filter  (Enrico Weigelt <weigelt@metux.de>)
List pgsql-sql
Enrico Weigelt wrote:
> Hi folks,
> 
> 
> Any hints for futher optimization appreciated :)
> 
> 
> thx


It doesn't look like you have any indexes - I'd add one to at least 
articles.title and blacklist.title to start with and probably also 
user_results.article_id and articles.inode_id.

-- 
Paul Lambert
Database Administrator
AutoLedgers



pgsql-sql by date:

Previous
From: Enrico Weigelt
Date:
Subject: Re: Database synchronization
Next
From: David Cottingham
Date:
Subject: Indexing a field of type point