Re: Having performance problems with TSearch2

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Rafa Comino <rafacomino(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Having performance problems with TSearch2
Date: 2007-02-20 11:15:27
Message-ID: 45DAD84F.7040701@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Use GIN index instead of GiST

> I have a table of books, with 1200000 registers. I have created an GIST
> index over the title and subtitle,
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marek Lewczuk 2007-02-20 11:43:12 Warning "TupleDesc reference leak"
Previous Message Rafa Comino 2007-02-20 11:10:39 Having performance problems with TSearch2

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2007-02-20 16:45:20 Re: Query Optimization
Previous Message Rafa Comino 2007-02-20 10:41:54 Having performance problems with TSearch2