On Thu, 11 Aug 2005, Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
The table contains ~10 million rows:
# time psql -c "UPDATE xa_url SET url = url;" -U pgsql pareto
ERROR: out of memory
DETAIL: Failed on request of size 32.
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?
Triggers:
xa_url_domain_b_i_u BEFORE INSERT OR UPDATE ON xa_url FOR EACH ROW EXECUTE
PROCEDURE xa_url_domain()
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
