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

From: sreekanth vajrapu <sreekanthvajrapu(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Query is slow when order by and limit clause are used in the query
Date: 2021-05-24 10:49:01
Message-ID: CAKPbTYioxLr=yv_iZfP2AHs3VeM_v8njgnBM5DofDpyhMTtBmQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bharath Rupireddy 2021-05-24 11:03:10 Re: Query is slow when order by and limit clause are used in the query
Previous Message David Rowley 2021-05-24 08:57:09 Re: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1