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

Поиск

Список

Период

Сортировка

От	Andreas Joseph Krogh
Тема	Re: Searching GIN-index (FTS) and sort by timestamp-column
Дата	16 марта 2016 г. 16:53:14
Msg-id	VisenaEmail.55.5cac9849d07151e7.1537fb2771f@tc7-visena обсуждение исходный текст
Ответ на	Re: Searching GIN-index (FTS) and sort by timestamp-column (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы	Re: Searching GIN-index (FTS) and sort by timestamp-column Re: Searching GIN-index (FTS) and sort by timestamp-column
Список	pgsql-performance

Дерево обсуждения

På onsdag 16. mars 2016 kl. 14:37:27, skrev Tom Lane <tgl@sss.pgh.pa.us>:

Andreas Joseph Krogh <andreas@visena.com> writes:
> 1. Why isnt' folder_id part of the index-cond?

Because a GIN index is useless for sorting.

> 2. Is there a way to make it use the (same) index to sort by
> received_timestamp?

No.

> 3. Using a GIN-index, is there a way to use the index at all for sorting?

No.

> 4. It doesn't seem like ts_rank uses the index for sorting either.

Same reason.

regards, tom lane

So it's basically impossible to use FTS/GIN with sorting on large datasets?

Are there any plans to improve this situation?

Thanks.

Andreas Joseph Krogh

CTO / Partner - Visena AS

Mobile: +47 909 56 963

andreas@visena.com

www.visena.com