"Katsaros Kwn/nos" <ntinos(at)aueb(dot)gr> writes:
> I read in the documentation of SPI functions that an SPI_cursor is used
> to avoid memory overrun in cases where a query returns many rows. I'd
> like to learn more about this. Is their any place that I could find more
> detailed information (e.g. max size of results, threshold - available
> memory etc.)?
You could look at plpgsql's use of SPI cursors for an example.
regards, tom lane