X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 602093A40C0 for ; Tue, 16 Nov 2004 15:33:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70680-04 for ; Tue, 16 Nov 2004 15:33:00 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 63FD33A40EB for ; Tue, 16 Nov 2004 15:33:03 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id iAGFWwWq001230 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Tue, 16 Nov 2004 08:33:01 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id iAGFWvKK006128; Tue, 16 Nov 2004 08:32:57 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id iAGFWvJu006127; Tue, 16 Nov 2004 08:32:57 -0700 (MST) (envelope-from mfuhr) Date: Tue, 16 Nov 2004 08:32:57 -0700 From: Michael Fuhr To: =?us-ascii?B?PT9pc28tODg1OS0xNT9xP0hlcnY9RTlfUGllZHZhY2hlPz0=?= Cc: pgsql-performance@postgresql.org Subject: Re: Tsearch2 really slower than ilike ? Message-ID: <20041116153256.GA6026@winnie.fuhr.org> References: <200411161555.59144.herve@elma.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=unknown-8bit Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200411161555.59144.herve@elma.fr> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/222 X-Sequence-Number: 9176 On Tue, Nov 16, 2004 at 03:55:58PM +0100, Hervé Piedvache wrote: > WHERE s.idx_site_name @@ to_tsquery('atari'); How much text does each site_name field contain? From the field name I'd guess only a few words. Based on my own experience, if the fields were documents containing thousands of words then I'd expect tsearch2 to be faster than ILIKE by an order of magnitude or more. -- Michael Fuhr http://www.fuhr.org/~mfuhr/