Re: [GENERAL] huge backend processes

> 
> maybe i'm doing something wrong here:
> 
> CREATE TABLE samples
>   (
>   mark      abstime,
>   subnet    inet,
>   bytes_in  float8,
>   bytes_out float8
>   );
> CREATE INDEX samples_mark ON samples (mark);
> 
> --- fill it with lots and lots of data
> 
> BEGIN WORK;
> DECLARE mycurs CURSOR FOR
>    SELECT DATE_PART('epoch', mark), subnet, bytes_in, bytes_out

This is clearly a known problem.  We need a per-tuple memory context. 
Function calls that return palloc'ed memory is not freed for each tuple.


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026