SPI memory overrun details

От:

"Katsaros Kwn/nos" <ntinos@aueb.gr>

Дата:

25 ноября 2004 г. в 13:33:43

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

Re: SPI memory overrun details

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

25 ноября 2004 г. в 16:15:43

"Katsaros Kwn/nos"  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