Home > mailing lists

Question about gin index not used on a tsv column - Mailing list pgsql-general

From	Patrick Dung
Subject	Question about gin index not used on a tsv column
Date	September 2, 2014 21:14:32
Msg-id	1409681663.88060.YahooMailNeo@web193505.mail.sg3.yahoo.com Whole thread Raw
Responses	Re: Question about gin index not used on a tsv column (David G Johnston <david.g.johnston@gmail.com>)
List	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

explain analyze on tsv and gin index.txt

pgsql-general by date:

Previous

From: Adrian Klaver
Date: 02 September 2014, 21:08:54
Subject: Re: copymanager question

Next

From: David G Johnston
Date: 02 September 2014, 21:59:50
Subject: Re: Question about gin index not used on a tsv column