Re: grep -f keyword data query

Andreas Kretschmer <andreas@a-kretschmer.de> writes:
>> Tom Lane <tgl@sss.pgh.pa.us> hat am 27. Dezember 2015 um 19:11 geschrieben:
>> What in the world is this @~ operator?  And what sort of index are
>> you using now, that can accept it?  Are the rowcount estimates in
>> the EXPLAIN output accurate?  (If they are, it's hardly surprising
>> that the query takes a long time.)

> in a privat mail he called an other operator: ~~. I think, the @~ is an error.

Well, ~~ isn't directly indexable by btree indexes either, so there's
still something wrong with either the EXPLAIN output or the claimed
index definitions.

            regards, tom lane