Question about gin index not used on a tsv column

From: Patrick Dung <patrick_dkt(at)yahoo(dot)com(dot)hk>
To: Pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Question about gin index not used on a tsv column
Date: 2014-09-02 18:14:23
Message-ID: 1409681663.88060.YahooMailNeo@web193505.mail.sg3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Postgresql users,

In my setting, I found that sometimes the query does not use the gin index built for a tsv column.

Attached file provide more info (with explain analyze).

Thanks and regards,
Patrick

Attachment Content-Type Size
explain analyze on tsv and gin index.txt text/plain 3.3 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-09-02 18:59:40 Re: Question about gin index not used on a tsv column
Previous Message Adrian Klaver 2014-09-02 18:08:49 Re: copymanager question