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 3ABF83A3C82 for ; Tue, 16 Nov 2004 16:05:24 +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 83756-02 for ; Tue, 16 Nov 2004 16:05:21 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id E667C3A3C42 for ; Tue, 16 Nov 2004 16:05:20 +0000 (GMT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id iAGG5F816661; Tue, 16 Nov 2004 08:05:15 -0800 Message-ID: <419A250C.9020300@commandprompt.com> Date: Tue, 16 Nov 2004 08:04:28 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: =?ISO-8859-15?Q?Herv=E9_Piedvache?= Cc: Michael Fuhr , pgsql-performance@postgresql.org Subject: Re: Tsearch2 really slower than ilike ? References: <200411161555.59144.herve@elma.fr> <20041116153256.GA6026@winnie.fuhr.org> <200411161648.11519.herve@elma.fr> In-Reply-To: <200411161648.11519.herve@elma.fr> Content-Type: multipart/mixed; boundary="------------020105030809020707080102" 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/225 X-Sequence-Number: 9179 This is a multi-part message in MIME format. --------------020105030809020707080102 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit >>or more. >> >> > >Yes site name ... is company names or web site name ... so not many word in >each record ... but I don't understand why more words are more efficient than >few words ?? sorry ... > > Well there are a couple of reasons but the easiest one is index size. An ILIKE btree index is in general going to be much smaller than a gist index. The smaller the index the faster it is searched. Sincerely, Joshua D. Drake >Regards, > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------020105030809020707080102 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------020105030809020707080102--