SPI memory overrun details
Hi,
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.)?
I searched the archives but nothing.
Regards,
Ntinos Katsaros
"Katsaros Kwn/nos" <ntinos@aueb.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