Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7F0DC9FA2F7 for ; Tue, 2 Oct 2007 18:05:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 19385-05 for ; Tue, 2 Oct 2007 18:05:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 13E139F9F8B for ; Tue, 2 Oct 2007 18:05:29 -0300 (ADT) Received: from [192.168.1.9] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l92L5Rbh020772 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 2 Oct 2007 14:05:28 -0700 Message-ID: <4702B2CC.20907@commandprompt.com> Date: Tue, 02 Oct 2007 14:06:20 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 2.0.0.6 (X11/20070924) MIME-Version: 1.0 To: Kevin Kempter CC: pgsql-performance@postgresql.org Subject: Re: performance of like queries References: <200710021131.46010.kevin@kevinkempterllc.com> In-Reply-To: <200710021131.46010.kevin@kevinkempterllc.com> X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.91.1/4452/Mon Oct 1 22:03:17 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 02 Oct 2007 14:05:28 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/6 X-Sequence-Number: 27028 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Kevin Kempter wrote: > Hi List; > > any suggestions for improving "LIKE '%text%'" queries? faster disks :) take a look at pg_tgrm and tsearch2. Sincerely, Joshua D. Drake > > > Thanks in advance > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHArLMATb/zqfZUUQRAiaSAJ4lbVKrKEgr9OnO6jDguALtnonm7QCggtsx W7dsy40KbvizyYBQYpvsIvw= =2J2G -----END PGP SIGNATURE-----