On Thu, 11 Aug 2005, Tom Lane wrote:
"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?
This is all I'm seeing in the logs:
# grep "\[653\]" pgsql
Aug 11 08:45:47 pgsql80 pg[653]: [34-1] ERROR: out of memory
Aug 11 08:45:47 pgsql80 pg[653]: [34-2] DETAIL: Failed on request of size 32.
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
