Re: Cursor-based results: bafflingly slow

Robin Houston wrote:

> For example, if I use "limit 100" to simulate the effect of fetching
> the first 100 results:

They're not really equivalent. A portal with a limited fetchsize is more
like DECLARE CURSOR, not LIMIT.

What does the plan look like if you plan it without the LIMIT?

-O