Re: Full text search with ORDER BY performance issue

Поиск
Список
Период
Сортировка
От worthy7
Тема Re: Full text search with ORDER BY performance issue
Дата
Msg-id 1406577313646-5813083.post@n5.nabble.com
обсуждение исходный текст
Ответ на Full text search with ORDER BY performance issue  (Krade <krade@krade.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Very slow planning performance on partition table
Следующее
От: Rural Hunter
Дата:
Сообщение: Re: Very slow planning performance on partition table