| From: | Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net> |
|---|---|
| To: | vic(dot)cekvenich(at)portalvu(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Text Search vs MYSQL vs Lucene |
| Date: | 2004-09-09 13:39:33 |
| Message-ID: | 200409091909.33934.shridhar@frodo.hserus.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2004-09-09 13:49:05 | Re: ERROR: parser: unterminated quoted string |
| Previous Message | Gaetano Mendola | 2004-09-09 13:33:21 | Re: postgresql hanging (blocking) with smp kernel |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vic Cekvenich | 2004-09-09 14:14:34 | Re: Text Search vs MYSQL vs Lucene |
| Previous Message | Vic Cekvenich | 2004-09-09 12:56:20 | Text Search vs MYSQL vs Lucene |