Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 66A952E023D for ; Mon, 28 Jan 2008 13:38:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 78247-01 for ; Mon, 28 Jan 2008 13:38:16 -0400 (AST) Received: from web36204.mail.mud.yahoo.com (web36204.mail.mud.yahoo.com [209.191.68.230]) by postgresql.org (Postfix) with SMTP id AA54A2E006E for ; Mon, 28 Jan 2008 13:38:16 -0400 (AST) Received: (qmail 21317 invoked by uid 60001); 28 Jan 2008 17:38:15 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=K8F4KT6m/bP4RXyKxe72QuheHsnTYnq291wYkmyAdUAgCwZaWqQlnmb3pFpGTfTmjiZOLrxy+1ldqTFCvId6m3oULXqSxGIk4ogSZgNzRJzz7XlQegd1rgHhd/aarisGfOGQGNR88kZmbbANqM//ELNtpFH4b3GtjxSnr8GcyJs=; X-YMail-OSG: a0aublUVM1lx5I8R3VUOaX4KGSB1U9DgL15WFYuJB4WqeQOTnG_8L2YKnrLKr3VXT4elJAvnd3JDq0UqcENWSRO9UxQvFk25U9PtjF6X0xjsnt3g_YQZ_36.esg5JA-- Received: from [200.250.55.253] by web36204.mail.mud.yahoo.com via HTTP; Mon, 28 Jan 2008 14:38:15 ART Date: Mon, 28 Jan 2008 14:38:15 -0300 (ART) From: "A.Burbello" Subject: Search string without tsearch To: Postgres Adm List MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <440310.20885.qm@web36204.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200801/264 X-Sequence-Number: 28038 Hi people, I would like to some suggestion to search person name in a table that has more than 150 milions of rows ... e.g ... name like 'JOHN%SMITH'; I know there is contrib Tsearch, but I can't for political reasons. Is there any way to do with good performance??? Thank you. Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/