> Is'nt the "blank portal" the name of the cursor you get when you just
> do a select without creating a cursor ?
Yes, is that still so ?
>
> > I don't really see any advantage, that psql does not do a fetch loop
> > with a portal.
>
> It only increases traffic, as explicit fetch commands need to be sent
> to backend. If one does not declare a cursor, an implicit
> fetch all from
> blank is performed.
I don't really see how a fetch every x rows (e.g.1000) would add significant
overhead.
The first fetch could still be done implicit, it would only fetch 1000
instead of fetch all.
Thus there would only be overhead for large result sets, where the
wasted memory is of real concern.
Andreas