>
> 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
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
************
Check out "PostgreSQL Wearables" @ http://www.pgsql.com
