Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DF66B2E00A2 for ; Mon, 28 Jan 2008 14:41:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 39904-07 for ; Mon, 28 Jan 2008 14:41:13 -0400 (AST) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id D66152E008D for ; Mon, 28 Jan 2008 14:41:14 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id r21so1114164wxc.28 for ; Mon, 28 Jan 2008 10:41:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=Xzu8jz5Kjjjh2AzM6dFYMetC51RTTWZ4TcjqUvnmQvE=; b=E1pxPsv1Eh1ukJzgXpvxhQsp7fp+jtYvvsLqCT0V/cXfQ4DxxgwcjednQ7uss7N330WqXlc+1mX4hnAT4pWfEIm39KwgqXkitiMpgXp7a91IJohnRKQhKNnYr0YTWpjWWR//Y1/BL36KBDCQ0j1ol7Y1e2kYsZDfn01oF47D9qs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=fVNXjIF8WVxibKM7rxbHwZnAQfMp9r8q43XMZR6EaLWr3auM94aMDv/eylGmv9L/aBYJMurqctf3F7VA7EdXTaM+Y7piH7WIh+QV9mkEr+xRdoZ7BG5Jbn8LVijlGQuJsBQgrnMWUtxvubE+pwKyZ2OgU61a/rYqMDrWBlglGMg= Received: by 10.115.95.1 with SMTP id x1mr1541230wal.94.1201545672772; Mon, 28 Jan 2008 10:41:12 -0800 (PST) Received: by 10.114.133.5 with HTTP; Mon, 28 Jan 2008 10:41:12 -0800 (PST) Message-ID: Date: Mon, 28 Jan 2008 12:41:12 -0600 From: "Scott Marlowe" To: A.Burbello Subject: Re: Search string without tsearch Cc: "Postgres Adm List" In-Reply-To: <440310.20885.qm@web36204.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <440310.20885.qm@web36204.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/265 X-Sequence-Number: 28039 On Jan 28, 2008 11:38 AM, A.Burbello wrote: > 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??? Would pointing out to the PHBs that tsearch was integrated into pgsql with v8.3 help convince them to stop being reactionary idiots?