Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> (I wonder whether we can't improve on that, at least for the case of a
>> non-deferred after trigger, which'd have already been fired before we
>> exit the subtransaction. The trick is how to know that there's nothing
>> useful left i
Tom Lane wrote:
> (I wonder whether we can't improve on that, at least for the case of a
> non-deferred after trigger, which'd have already been fired before we
> exit the subtransaction. The trick is how to know that there's nothing
> useful left in the subtransaction's per-transaction memory co
"Henry - Zen Search SA" <[EMAIL PROTECTED]> writes:
> On Fri, June 13, 2008 7:05 pm, Tom Lane wrote:
>> The memory overhead per subtransaction is
>> not zero, though I think it's fairly small if you don't have any
>> triggers pending as a result of the insert.
> Two triggers are fired for each ins
On Fri, June 13, 2008 7:05 pm, Tom Lane wrote:
> How soon is "bang"?
I'll run it again and post back.
> The memory overhead per subtransaction is
> not zero, though I think it's fairly small if you don't have any
> triggers pending as a result of the insert.
Two triggers are fired for each inser
"Henry - Zen Search SA" <[EMAIL PROTECTED]> writes:
> One other thing: the docs mention that functions use cursors
> automatically to prevent OOM errors on large selects (as in my case).
> Well, the second part of my function does this:
> FOR rec in SELECT * FROM bigtable
> LOOP
>...begin/in
On Mon, June 2, 2008 6:53 pm, Tom Lane wrote:
> I don't think your problem has anything to do with dblink per se.
> The repeated begin/exception blocks are apparently managing to leak
> some memory per iteration. I can't tell whether this represents
> a known (and perhaps already fixed) bug; it ve
On Mon, June 2, 2008 6:53 pm, Tom Lane wrote:
> "Henry" <[EMAIL PROTECTED]> writes:
>> I'm trying to code a function to copy rows from one machine to another
>> using dblink and cursors:
>
> What PG version is this, exactly?
Arg, dammit. Sorry, it's version 8.2.6 (where the function is running),
"Henry" <[EMAIL PROTECTED]> writes:
> I'm trying to code a function to copy rows from one machine to another
> using dblink and cursors:
What PG version is this, exactly?
> perform dblink_connect ('dbname=db1...host=othermachine.com');
> perform dblink_open ('cur_other1', 'SELECT col1 FROM tab1')
Hello all,
I'm trying to code a function to copy rows from one machine to another
using dblink and cursors:
...
perform dblink_connect ('dbname=db1...host=othermachine.com');
perform dblink_open ('cur_other1', 'SELECT col1 FROM tab1');
loop
fnd := 0;
for rec in
-- grab a 1000 rows at a