I hate to be "that guy" but, Is this is still an issue 5 years later?? I can't seem to get Gin/btree to use my ORDER BY column with a LIMIT no matter what I try.
My best idea was to cluster the database by the ORDER BY column and then just hope the index returns them in the order in the table... -- View this message in context: http://postgresql.1045698.n5.nabble.com/Full-text-search-with-ORDER-BY-performance-issue-tp2074171p5813083.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
