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 [EMAIL PROTECTED])
--
Please post on Rich Internet Applications User Interface (RiA/SoA) <http://www.portalvu.com>
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
