"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> On Thu, 11 Aug 2005, Tom Lane wrote:
>> If you've got any AFTER UPDATE triggers on that table, you could be
>> running out of memory for the pending-triggers list.
> Nope, only have a BEFORE UPDATE, or would that be similar except for at
> which point it runs out of memory?
Nope, BEFORE UPDATE shouldn't result in any permanent memory
accumulation.
An out-of-memory error should result in a long report in the postmaster
log about how many bytes in each memory context --- can you post that?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
