| From: | AI Rumman <rummandba(at)gmail(dot)com> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | mabewlun(at)gmail(dot)com, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: query hangs |
| Date: | 2010-06-10 12:35:03 |
| Message-ID: | AANLkTilYphFD0_ywMnm5I0SbyXnnJ54VQseMMFO38yrm@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(dot)Grittner(at)wicourts(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Khandekar | 2010-06-10 12:55:54 | Re: query hangs |
| Previous Message | Kevin Grittner | 2010-06-10 12:28:06 | Re: query hangs |