X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7C1D432A828 for ; Tue, 19 Oct 2004 04:42:56 +0100 (BST) 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 24575-05 for ; Tue, 19 Oct 2004 03:42:47 +0000 (GMT) Received: from rodrick.geeknet.com.au (ns1.geeknet.com.au [220.244.63.182]) by svr1.postgresql.org (Postfix) with ESMTP id 0EC9A32A1C9 for ; Tue, 19 Oct 2004 04:42:45 +0100 (BST) Received: from john.oztralis.com.au ([192.168.63.107]) by rodrick.geeknet.com.au with Microsoft SMTPSVC(6.0.3790.0); Tue, 19 Oct 2004 13:42:44 +1000 Subject: Re: mailing list offer From: John Hansen To: "Joshua D. Drake" Cc: PostgreSQL www In-Reply-To: <417488FB.8050908@commandprompt.com> References: <41746DC7.2060003@commandprompt.com> <1098155495.15522.19.camel@localhost.localdomain> <417488FB.8050908@commandprompt.com> Content-Type: text/plain Organization: GeekNET Message-Id: <1098157289.15522.22.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Tue, 19 Oct 2004 13:41:30 +1000 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 19 Oct 2004 03:42:44.0512 (UTC) FILETIME=[B16FB200:01C4B58D] 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: 200410/186 X-Sequence-Number: 5580 On Tue, 2004-10-19 at 13:24, Joshua D. Drake wrote: > I have a database now with 1.77 million entries using Tsearch. The > entries are book titles. It runs > very well. There are some tricks to it though. For example what we had > to was have a single > table that has nothing but a product_id, title, title_vectors. Ok, i'm guessing none of the titles are as long as an email... what's the speed like? ... John