Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C1D889FB8AC for ; Wed, 8 Aug 2007 19:14:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 93665-01 for ; Wed, 8 Aug 2007 19:14:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from rrmailscan3.safenetbox.biz (mailscan3.reynolds.com.au [203.25.40.75]) by postgresql.org (Postfix) with ESMTP id BF0749FB482 for ; Wed, 8 Aug 2007 19:14:51 -0300 (ADT) Received: from rrmailscan3.safenetbox.biz (rrmailscan3.safenetbox.biz [127.0.0.1]) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id EA0FB1D48448 for ; Thu, 9 Aug 2007 08:14:49 +1000 (EST) Received: from [127.0.0.1] (online4-new.lnk.telstra.net [139.130.169.227]) (Authenticated sender: remote) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id A8A6C1D48444 for ; Thu, 9 Aug 2007 08:14:48 +1000 (EST) Message-ID: <46BA400F.2080704@autoledgers.com.au> Date: Thu, 09 Aug 2007 06:13:35 +0800 From: Paul Lambert User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: pgsql-sql Subject: Re: Implementing an regex filter References: <20070808121611.GA27936@nibiru.local> In-Reply-To: <20070808121611.GA27936@nibiru.local> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/52 X-Sequence-Number: 28990 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