Postgres Pro
Downloads
Home   >   mailing lists

Re: Search for fixed set of keywords - Mailing list pgsql-performance

From Jörg Kiegeland
Subject Re: Search for fixed set of keywords
Date
Msg-id 4785E423.8090005@ikv.de
Whole thread Raw
In response to Re: Search for fixed set of keywords  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: Search for fixed set of keywords
List pgsql-performance
Tree view 
> 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.

pgsql-performance by date:

Previous
From: Adrian Moisey
Date:
Subject: Re: big database performance
Next
From: Stephane Bailliez
Date:
Subject: Re: big database performance