Could you please give me the link for cursor- How to use it? On Thu, Jun 10, 2010 at 6:28 PM, Kevin Grittner <kevin.gritt...@wicourts.gov > wrote:
> AI Rumman wrote: > > >> Merge Left Join (cost=9500.30..101672.51 rows=2629549 width=506) > > > And the query does not return data though I have been waiting for > > 10 mins. > > > > Do you have any idea ? > > Unless you use a cursor, PostgreSQL interfaces typically don't show > any response on the client side until all rows have been received and > cached on the client side. That's estimated to be over 2.6 million > rows in this case. That can take a while. > > You might want to use a cursor.... > > -Kevin >
