Re: query hangs
| От | AI Rumman |
|---|---|
| Тема | Re: query hangs |
| Дата | |
| Msg-id | AANLkTilYphFD0_ywMnm5I0SbyXnnJ54VQseMMFO38yrm@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: query hangs ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
| Ответы |
Re: query hangs
|
| Список | 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.Grittner@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 forUnless you use a cursor, PostgreSQL interfaces typically don't show
> 10 mins.
>
> Do you have any idea ?
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
В списке pgsql-performance по дате отправления: