Query is slow when order by and limit clause are used in the query

Поиск
Список
Период
Сортировка
От sreekanth vajrapu
Тема Query is slow when order by and limit clause are used in the query
Дата
Msg-id CAKPbTYioxLr=yv_iZfP2AHs3VeM_v8njgnBM5DofDpyhMTtBmQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Query is slow when order by and limit clause are used in the query  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Re: Query is slow when order by and limit clause are used in the query  (David Fetter <david@fetter.org>)
Список pgsql-bugs
Дерево обсуждения

Hi Team,

We are having a slow query issue for one of our applications. We are seeing slowness(5 seconds) when we use both ORDER BY and LIMIT 30 clause whereas the same query is performing very good(200 MS) when using only ORDER BY clause.  Also note that the query performed very fast(200 MS) when we increased LIMIT to 100 along with ORDER  BY. 


Can you please help us if there are any bugs related to this?  OR Can someone kindly provide some solution to this issue?



--
Thanks & Regards,
Sreekanth

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Query is slow when order by and limit clause are used in the query