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

От: Andreas Joseph Krogh
Тема: Re: Searching GIN-index (FTS) and sort by timestamp-column
Дата: ,
Msg-id: VisenaEmail.ea.7101c678aa3b84c3.153859f7473@tc7-visena
(см: обсуждение, исходный текст)
Ответ на: Re: Searching GIN-index (FTS) and sort by timestamp-column  (Tom Lane)
Ответы: Re: Searching GIN-index (FTS) and sort by timestamp-column  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh, )
 Re: Searching GIN-index (FTS) and sort by timestamp-column  (Tom Lane, )
  Re: Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh, )
   Re: Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh, )
   Re: Searching GIN-index (FTS) and sort by timestamp-column  (Jeff Janes, )
    Re: Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh, )
     Re: Searching GIN-index (FTS) and sort by timestamp-column  (Oleg Bartunov, )
      Re: Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh, )
    Re: Searching GIN-index (FTS) and sort by timestamp-column  (Oleg Bartunov, )
     Re: Searching GIN-index (FTS) and sort by timestamp-column  (Jeff Janes, )
  Re: Searching GIN-index (FTS) and sort by timestamp-column  (Evgeniy Shishkin, )
   Re: Searching GIN-index (FTS) and sort by timestamp-column  (Evgeniy Shishkin, )
    Re: Searching GIN-index (FTS) and sort by timestamp-column  (Evgeniy Shishkin, )
     Re: Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh, )
     Re: Searching GIN-index (FTS) and sort by timestamp-column  (Tom Lane, )
      Re: Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh, )
       Re: Searching GIN-index (FTS) and sort by timestamp-column  (Tom Lane, )
    Re: Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh, )

På torsdag 17. mars 2016 kl. 18:20:23, skrev Tom Lane <>:
Evgeniy Shishkin <> 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
 
Thanks for info.
 
Can you explain why it works when using prepared statement without casting? Does the machinary then know the type so the "setParameter"-call uses the correct type?
 
Thanks.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Вложения

В списке pgsql-performance по дате сообщения:

От: "Mike Sofen"
Дата:
Сообщение: Re: Disk Benchmarking Question
От: Albe Laurenz
Дата:
Сообщение: Re: using shared_buffers during seq_scan