Re: dblink() cursor error/issue (TopMemoryContext) - Mailing list pgsql-general

From Henry - Zen Search SA
Subject Re: dblink() cursor error/issue (TopMemoryContext)
Date
Msg-id 0111e2042ddcf6e90a90feced97d468f.squirrel@zenmail.co.za
Whole thread Raw
In response to Re: dblink() cursor error/issue (TopMemoryContext)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: dblink() cursor error/issue (TopMemoryContext)
List pgsql-general
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 insert (before and after trigs).

> (Hm ... any foreign keys on the table being inserted into?)

Not on the table being inserted into, but it has a couple of tables with
foreign keys referencing it.


pgsql-general by date:

Previous
From: D Galen
Date:
Subject: Lost psql.exe on 8.3.3 upgrade
Next
From: Chander Ganesan
Date:
Subject: Re: Backup using GiT?