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 180CE3A230E for ; Tue, 16 Nov 2004 16:07:17 +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 84131-05 for ; Tue, 16 Nov 2004 16:07:15 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id C99BE3A3CE5 for ; Tue, 16 Nov 2004 16:07:14 +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 iAGG7C817227; Tue, 16 Nov 2004 08:07:12 -0800 Message-ID: <419A2581.2050409@commandprompt.com> Date: Tue, 16 Nov 2004 08:06:25 -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: pgsql-performance@postgresql.org Subject: Re: Tsearch2 really slower than ilike ? References: <200411161555.59144.herve@elma.fr> In-Reply-To: <200411161555.59144.herve@elma.fr> Content-Type: multipart/mixed; boundary="------------000300000904030804060907" 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/226 X-Sequence-Number: 9180 This is a multi-part message in MIME format. --------------000300000904030804060907 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit > > QUERY PLAN >---------------------------------------------------------------------------------------------------------------- > Seq Scan on site_rss s (cost=0.00..11863.16 rows=295 width=158) (actual >time=17.414..791.937 rows=12 loops=1) > Filter: (site_name ~~* '%atari%'::text) > SubPlan > -> Seq Scan on user_choice u (cost=0.00..3.46 rows=1 width=4) (actual >time=0.222..0.222 rows=0 loops=12) > Filter: ((id_site = $0) AND (id_user = 1)) > Total runtime: 792.099 ms > >First time I run the request I have a result in about 789 miliseconds !!??? > >I'm using PostgreSQL v7.4.6 with a Bi-Penitum III 933 Mhz and 1 Gb of RAM. > >Any idea ... ? For the moment I'm going back to use the ilike solution ... but >I was really thinking that Tsearch2 could be a better solution ... > > > Well I would be curious about what happens the second time you run the query. The first time is kind of a bad example because it has to push the index into ram. 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 --------------000300000904030804060907 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 --------------000300000904030804060907--