You need to use a cursor for that. The problem with the fetchsize
mechanism is that it doesn't give the planner any clue that the user might not intend to fetch the whole result, or might prefer low startup cost to low total cost anyway.
Thank you very much (and Oliver too). That's what I needed to know. I'll change my code to use explicit cursors.