X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id C7B32925B2B for ; Wed, 28 May 2003 16:52:58 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 37298-02 for ; Wed, 28 May 2003 16:52:57 -0400 (EDT) Received: from elbereth.noviforum.si (unknown [193.189.169.66]) by developer.postgresql.org (Postfix) with ESMTP id C4054925B0E for ; Wed, 28 May 2003 16:52:56 -0400 (EDT) Received: (from gregab@localhost) by elbereth.noviforum.si (8.11.4/8.11.4) id h4SKquo25416 for pgsql-performance@postgresql.org; Wed, 28 May 2003 22:52:56 +0200 Date: Wed, 28 May 2003 22:52:56 +0200 From: Grega Bremec To: pgsql-performance@postgresql.org Subject: Re: Wildcard searches & performance question Message-ID: <20030528225256.A24693@elbereth.noviforum.si> References: <20030527210908.A571@elbereth.noviforum.si> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20030527210908.A571@elbereth.noviforum.si>; from grega.bremec@noviforum.si on Tue, May 27, 2003 at 09:09:08PM +0200 Organization: Noviforum, Ltd., Software & Media X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/251 X-Sequence-Number: 2030 Thank you very much for all your suggestions. I am planning on investing some time into trying out a couple FT indexes. Not minding the fact most of the queries are going to be exact phrase substring searches, performance will most probably benefit from it, so at least some of what I'm after is achieved that way. I shall be getting back with reports, in case anyone is interested. Cheers, -- Grega Bremec System Administration & Development Support grega.bremec-at-noviforum.si http://najdi.si/ http://www.noviforum.si/