Re: Search for fixed set of keywords

From: Jörg Kiegeland <kiegeland(at)ikv(dot)de>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Search for fixed set of keywords
Date: 2008-01-10 09:23:47
Message-ID: 4785E423.8090005@ikv.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Did you try integer arrays with GIN (inverted index) ?
I now tried this, and GIN turned out to be linear time, compared with
GIST which was acceptable time. However I tested this only for
Z=infinity, for Z=1000, GIST/GIN are both not acceptable.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephane Bailliez 2008-01-10 11:08:39 Re: big database performance
Previous Message Adrian Moisey 2008-01-10 08:57:46 Re: big database performance