Re: Cursors: getting the number of tuples; moving backwards - Mailing list pgsql-general

From Tom Lane
Subject Re: Cursors: getting the number of tuples; moving backwards
Date
Msg-id 17095.1036206197@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cursors: getting the number of tuples; moving backwards  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Cursors: getting the number of tuples; moving backwards  (am@fx.ro)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
>> I guess it doesn't execute the whole query. MOVE ALL is *much*
>> faster than FETCH ALL + PQcmdTuples

> Curious. I wonder how it does it then.

MOVE does execute the query, it just doesn't ship the tuples to the
client.  This would save some formatting overhead (no need to run
the datatype I/O conversion procedures), but unless you have a slow
network link between client and server I would not expect it to be
"much" faster ...

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Cursors: getting the number of tuples; moving backwards
Next
From: Bruce Momjian
Date:
Subject: Re: CREATE TABLE oddity?