Re: [PERFORM] GIN index always doing Re-check condition, postgres 9.1

On Sun, Nov 1, 2015 at 10:52 PM, Andrey Osenenko wrote: > I have a table with roughly 300 000 rows, each row containing two large > strings - one is news article HTML, the other is news article plaintext. The > table has a bigint primary key. > > A GIN index is used to do fulltext search on the pl

[PERFORM] GIN index always doing Re-check condition, postgres 9.1

I have a table with roughly 300 000 rows, each row containing two large strings - one is news article HTML, the other is news article plaintext. The table has a bigint primary key. A GIN index is used to do fulltext search on the plaintext part. All I want to retrieve when I do fulltext search is