Postgres Pro
Downloads
Home   >   mailing lists

Re: Full text search with ORDER BY performance issue - Mailing list pgsql-performance

From worthy7
Subject Re: Full text search with ORDER BY performance issue
Date
Msg-id 1406577313646-5813083.post@n5.nabble.com
Whole thread Raw
In response to Full text search with ORDER BY performance issue  (Krade <krade@krade.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Very slow planning performance on partition table
Next
From: Rural Hunter
Date:
Subject: Re: Very slow planning performance on partition table