Re: dblink memory leak - Mailing list pgsql-hackers

From Joe Conway
Subject Re: dblink memory leak
Date
Msg-id 4ACA30DB.3000003@joeconway.com
Whole thread Raw
In response to Re: dblink memory leak  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: dblink memory leak  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: dblink memory leak  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tom Lane wrote:
> Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
>> I think PG_TRY blocks are not enough, too. PG_TRY requires a statement
>> block, but we need to return from dblink functions per tuple.
>
> That bit will have to be undone.  There is no reason for dblink not to
> return a tuplestore.

That's a really good point. It was originally written thinking we would
eventually be able to stream tuples rather than materialize them, but
given that many years have passed and we are no closer (I believe) to a
true streaming mode for SRFs, a tuplestore would be much cleaner.

Given that change, is there even any leak to even worry about? As long
as the PGresult object is created in the correct memory context, it
ought to get cleaned up automatically, no?

I can't promise to make this change before 15 October, but I will get to
it before the end of CF3.

Joe



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Privileges and inheritance
Next
From: Peter Eisentraut
Date:
Subject: Re: Privileges and inheritance