pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Vic Cekvenich <vic.cekvenich@portalvu.com>
To: pgsql-general@postgresql.org
Subject: Re: Text Search vs MYSQL vs Lucene
Date: Thu, 09 Sep 2004 09:14:34 -0500
Message-ID: <4140654A.1000407@portalvu.com> (raw)
In-Reply-To: <200409091909.33934.shridhar@frodo.hserus.net>
References: <414052F4.5050000@portalvu.com>
	<200409091909.33934.shridhar@frodo.hserus.net>

It be at least dual opteron 64 w 4 gigs of ram runing fedora with a huge 
raid striped drives as single volume.
A similar system and types of querries would be this:
http://marc.theaimsgroup.com

So I guess a table scan.


.V

Shridhar Daithankar wrote:

>On Thursday 09 Sep 2004 6:26 pm, Vic Cekvenich wrote:
>  
>
>>What would be performance of pgSQL text search vs MySQL vs Lucene (flat
>>file) for a 2 terabyte db?
>>    
>>
>
>Well, it depends upon lot of factors. There are few questions to be asked 
>here..
>- What is your hardware and OS configuration?
>- What type of data you are dealing with? Mostly static or frequently updated?
>- What type of query you are doing. Aggregates or table scan or selective 
>retreival etc.
>
>Unfortunately there is no one good answer. If you could provide details, it 
>would help a lot..
>
> Shridhar
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>  
>


-- 
Please post on Rich Internet Applications User Interface (RiA/SoA) 
<http://www.portalvu.com;



view thread (6+ messages)  latest in thread

Message-ID: <4140654A.1000407@portalvu.com>
Permalink:  ../4140654A.1000407@portalvu.com/
Also on:    postgresql.org/message-id/4140654A.1000407@portalvu.com

 · 

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: pgsql-performance@postgresql.org
  Cc: vic.cekvenich@portalvu.com, pgsql-general@postgresql.org
  Subject: Re: Text Search vs MYSQL vs Lucene
  In-Reply-To: <4140654A.1000407@portalvu.com>

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

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