Re: Slow query when using ORDER BY *and* LIMIT

Поиск
Список
Период
Сортировка
От davidsarmstrong
Тема Re: Slow query when using ORDER BY *and* LIMIT
Дата
Msg-id 1318534448999-4900348.post@n5.nabble.com
обсуждение исходный текст
Ответ на Slow query when using ORDER BY *and* LIMIT  (Jonathan <jonathan@kc8onw.net>)
Ответы Re: Slow query when using ORDER BY *and* LIMIT  (Michael Viscuso <michael.viscuso@getcarbonblack.com>)
Список pgsql-performance
Дерево обсуждения 
I'm running into the same problem. I removed the limit and it was fine. I
guess I could have removed the order by as well but it doesn't help if you
really need both.

Have you found any more information on this?

Thanks!

Dave (Armstrong)

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Slow-query-when-using-ORDER-BY-and-LIMIT-tp4555260p4900348.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Vishnu S."
Дата:
Сообщение: Tablespace files deleted automatically.
Следующее
От: Svetlin Manavski
Дата:
Сообщение: Join over two tables of 50K records takes 2 hours