Re: can't get async mode to deliver small batches of rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Harrison <mh(at)pixar(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: can't get async mode to deliver small batches of rows
Date: 2004-05-21 07:07:15
Message-ID: 24979.1085123235@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mark Harrison <mh(at)pixar(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-05-21 08:36:03 Re: Porting SQL Server 2000 database to PostgreSQL
Previous Message Tom Lane 2004-05-21 07:04:08 Re: reading vacuum verbosity