Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> writes: >> Tom Lane <tgl@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
