What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
thanks for any comments.
.V
--
Please post on Rich Internet Applications User Interface (RiA/SoA)
http://www.portalvu.com
---(end of broadcast)---
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
On Thu, Sep 09, 2004 at 07:56:20AM -0500, Vic Cekvenich wrote:
What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
thanks for any comments.
My experience with tsearch2 has been that indexing even moderately
large chunks of data is too slow to be
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
Steve Atkins wrote:
What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
thanks for any comments.
My experience with tsearch2 has been that indexing even moderately
large chunks of data is too slow to be feasible. Moderately large
meaning tens of