Re: [PERFORM] Upgrade to dual processor machine? - Mailing list pgsql-general

From jmelesky@performics.com
Subject Re: [PERFORM] Upgrade to dual processor machine?
Date
Msg-id 20021114213146.60390476B0C@postgresql.org
Whole thread Raw
In response to Re: Upgrade to dual processor machine?  ("Henrik Steffen" <steffen@city-map.de>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Vassil Kriakov
Date:
Subject: C++: get value for integral types?
Next
From: Alvaro Herrera
Date:
Subject: Re: running query