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 27201.1458135447@sss.pgh.pa.us
Whole thread Raw
In response to Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: Searching GIN-index (FTS) and sort by timestamp-column  (Andreas Joseph Krogh <andreas@visena.com>)
Re: Searching GIN-index (FTS) and sort by timestamp-column  (Evgeniy Shishkin <itparanoia@gmail.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Searching GIN-index (FTS) and sort by timestamp-column
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: Searching GIN-index (FTS) and sort by timestamp-column