Large Selects and cursors.. - Mailing list pgsql-general

From Ow Mun Heng
Subject Large Selects and cursors..
Date
Msg-id 1220577738.11681.4.camel@neuromancer.home.net
Whole thread Raw
List pgsql-general
Hi,
 I frequently query PG for between 10k - 65k rows of data and was
wondering if I should be considering usage of cursors.

I’m not too well versed with it’s purpose but based on the docs, it is
supposed to be more efficient and also gives the impression of
responsiveness.

Currently, when I do these large selects, there will be a few minutes
(to tens of minutes) of unresponsiveness before the results come out.


pgsql-general by date:

Previous
From: Christophe
Date:
Subject: Re: Postgres does not start, gives no error
Next
From: "Fernando Moreno"
Date:
Subject: Re: offtopic, about subject prefix