public inbox for [email protected]  

help / color / mirror / Atom feed

From: Joshua D. Drake <[email protected]>
To: John Hansen <[email protected]>
Cc: PostgreSQL www <[email protected]>
Subject: Re: mailing list offer
Date: Mon, 18 Oct 2004 21:09:20 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

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 - [email protected] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

view thread (22+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: mailing list offer
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox