Comment by mkleczek

I am still looking for a good solution to the following use case:

create table entry (id, user, entry_date, entry_text);

select * from entry where user = ? and entry_date <= ? and entry_text matches ? order by entry_date desc limit ?;

(eg. page through the list of financial transactions with description matching some criteria, latest first)

So far only GIST with pg_trgm handles that without the need to sort large result sets.