Re: SPI memory overrun details - Mailing list pgsql-general

From Tom Lane
Subject Re: SPI memory overrun details
Date
Msg-id 29639.1101399248@sss.pgh.pa.us
Whole thread Raw
In response to SPI memory overrun details  ("Katsaros Kwn/nos" <ntinos@aueb.gr>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Happy Thanksgiving
Next
From: Tom Lane
Date:
Subject: Re: VACUUM ANALYZE question - PostgreSQL performance tests