Re: Searching GIN-index (FTS) and sort by timestamp-column

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Searching GIN-index (FTS) and sort by timestamp-column
Дата
Msg-id 2279.1458235223@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Searching GIN-index (FTS) and sort by timestamp-column  (Evgeniy Shishkin <itparanoia@gmail.com>)
Ответы Re: Searching GIN-index (FTS) and sort by timestamp-column
Список pgsql-performance
Дерево обсуждения 
Evgeniy Shishkin <itparanoia@gmail.com> writes:
> Uh, it works if i cast to bigint explicitly

FWIW, the reason for that is that the int8_ops operator class that
btree_gin creates doesn't contain any cross-type operators.  Probably
wouldn't be that hard to fix if somebody wanted to put in the work.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Rick Otten
Дата:
Сообщение: Re: using shared_buffers during seq_scan
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Searching GIN-index (FTS) and sort by timestamp-column