Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views

From: Vivek Khera <vivek(at)khera(dot)org>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
Date: 2007-08-27 14:43:19
Message-ID: FC20AF04-79FC-4F64-AF21-90957BB4337E@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance


On Aug 25, 2007, at 1:34 AM, Benjamin Arai wrote:

> There has to be another way to do incremental indexing without
> loosing that much performance.

This is the killer feature that prevents us from using the tsearch2
full text indexer on postgres. we're investigating making a foreign
table from a SOLR full text index so our app only talks to Pg but the
text search is held in a good index.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2007-08-27 14:46:53 Re: LDAP service lookup
Previous Message Joseph S 2007-08-27 13:28:40 Re: [ANNOUNCE] == PostgreSQL Weekly News - August 26 2007 ==

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2007-08-27 14:45:20 Re: Performance issue
Previous Message Willo van der Merwe 2007-08-27 13:41:42 Performance issue