Re: [HACKERS] libpq: why we need to fetch all rows? - Mailing list pgsql-hackers

On Sun, 29 Jun 1997, Bruce Momjian wrote:

> >
> > On Sun, 29 Jun 1997, Bruce Momjian wrote:
> >
> > > > On Sun, 29 Jun 1997, Bruce Momjian wrote:
>
> But then, what is the goal?  A temp table is going to be a performance
> hit, and so is passing one row at a time from the backend.

I see two goals, first you save memory on the client.  Next you
improve performance since you don't have to transfer all of a large
dataset to a client.  On a multi-megabyte result this can be a
very big win.

Of course I may be misunderstanding the issue.

Mike Miller             mke@netcom.com
- -
(Pseudo advertising ahead)
Check out MySQL (http://www.tcx.se/), a mostly free lightning fast SQL DB.
And my manual for MySQL (http://mysql.turbolift.com/)

------------------------------