| From: | jmelesky(at)performics(dot)com |
|---|---|
| To: | steffen(at)city-map(dot)de |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Upgrade to dual processor machine? |
| Date: | 2002-11-14 21:26:05 |
| Message-ID: | 20021114213146.60014476B03@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On 14 Nov, Henrik Steffen wrote:
> of course, there are some seq scans... one of the most
> difficult queries is for example a kind of full text
> search, that searches through 8 different tables with
> each between 300.000 and 500.000 rows and 5-50 columns,
> but that's a different issue (need a full-text-search-engine...)
Ah, well, it may be worthwhile to check out fulltextindex or tsearch
in contrib/. They both require some changes to the way you do queries,
but they may be helpful in speeding up those queries.
-johnnnnnnnnn
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-11-14 21:28:29 | Re: [PERFORM] Upgrade to dual processor machine? |
| Previous Message | Robert Treat | 2002-11-14 21:15:23 | Re: OT: php3 compatibility? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-11-14 21:28:29 | Re: [PERFORM] Upgrade to dual processor machine? |
| Previous Message | Medi Montaseri | 2002-11-14 21:05:26 | Re: [PERFORM] Upgrade to dual processor machine? |