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 06DCF32A929 for ; Tue, 19 Oct 2004 05:11:25 +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 34003-03 for ; Tue, 19 Oct 2004 04:11:23 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 0D51332A226 for ; Tue, 19 Oct 2004 05:11:19 +0100 (BST) 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 i9J4BHU01338; Mon, 18 Oct 2004 21:11:17 -0700 Message-ID: <41749370.3000003@commandprompt.com> Date: Mon, 18 Oct 2004 21:09:20 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) X-Accept-Language: en-us, en MIME-Version: 1.0 To: John Hansen Cc: PostgreSQL www Subject: Re: mailing list offer References: <41746DC7.2060003@commandprompt.com> <1098155495.15522.19.camel@localhost.localdomain> <417488FB.8050908@commandprompt.com> <1098157289.15522.22.camel@localhost.localdomain> In-Reply-To: <1098157289.15522.22.camel@localhost.localdomain> Content-Type: multipart/alternative; boundary="------------060501050705060204080303" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE, HTML_TITLE_EMPTY X-Spam-Level: * X-Archive-Number: 200410/187 X-Sequence-Number: 5581 This is a multi-part message in MIME format. --------------060501050705060204080303 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit John Hansen wrote: >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? > > > 1.4 seconds for the search, 4.5ms for the pull of the full details.. So no -- that may not scale that well. We would have to test it out. Sincerely, Joshua D. Drake >... John > > -- 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 --------------060501050705060204080303 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit John Hansen wrote:

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?

1.4 seconds for the search, 4.5ms for the pull of the full details..

So no -- that may not scale that well. We would have to test it out.

Sincerely,

Joshua D. Drake

... John

-- 
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

--------------060501050705060204080303--