Re: Searching GIN-index (FTS) and sort by timestamp-column - Mailing list pgsql-performance

From Tom Lane
Subject Re: Searching GIN-index (FTS) and sort by timestamp-column
Date
Msg-id 2279.1458235223@sss.pgh.pa.us
Whole thread Raw
In response to Re: Searching GIN-index (FTS) and sort by timestamp-column  (Evgeniy Shishkin <itparanoia@gmail.com>)
Responses Re: Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh <andreas@visena.com>)
List 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 by date:

Previous
From: Rick Otten
Date:
Subject: Re: using shared_buffers during seq_scan
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: Searching GIN-index (FTS) and sort by timestamp-column