Re: Implementing an regex filter

From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Implementing an regex filter
Date: 2007-08-08 22:13:35
Message-ID: 46BA400F.2080704@autoledgers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-08-09 01:51:48 Re: When/if to Reindex
Previous Message Bryan Murphy 2007-08-08 20:57:52 Re: How to ENABLE SQL capturing???

Browse pgsql-sql by date

  From Date Subject
Next Message Arindam Hore 2007-08-09 06:23:42 pg_trgm installation
Previous Message Enrico Weigelt 2007-08-08 13:15:52 Re: Database synchronization