Postgres Pro
Downloads
Home   >   mailing lists

Re: can't get async mode to deliver small batches of rows - Mailing list pgsql-general

From Tom Lane
Subject Re: can't get async mode to deliver small batches of rows
Date
Msg-id 24979.1085123235@sss.pgh.pa.us
Whole thread Raw
In response to can't get async mode to deliver small batches of rows  (Mark Harrison <mh@pixar.com>)
List pgsql-general
Tree view 
Mark Harrison <mh@pixar.com> writes:
> I can't seem to get PG into non-blocking mode.

"Non-blocking" does not mean "will deliver an incomplete result".
It just means you can get control back while waiting for the complete
result (though not with the code you show...)

You probably want to think about creating a cursor and FETCHing
a few rows per query.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: reading vacuum verbosity
Next
From: Richard Huxton
Date:
Subject: Re: Porting SQL Server 2000 database to PostgreSQL