Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-12 Thread Marc G. Fournier
On Thu, 11 Aug 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: On Thu, 11 Aug 2005, Tom Lane wrote: Are you *sure* there are no AFTER triggers here? (Don't forget foreign-key checking triggers.) This is all of them ... nothing AFTER, just ON or BEFORE ... Foreign-key

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > On Thu, 11 Aug 2005, Tom Lane wrote: >> Are you *sure* there are no AFTER triggers here? >> (Don't forget foreign-key checking triggers.) > This is all of them ... nothing AFTER, just ON or BEFORE ... > Foreign-key constraints: > "xa_classific

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
On Thu, 11 Aug 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: 'k, does this help any? TopMemoryContext: 40960 total in 4 blocks; 8632 free (10 chunks); 32328 used SPI Plan: 3072 total in 2 blocks; 1728 free (0 chunks); 1344 used TopTransactionContext: 534765568 total in

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > 'k, does this help any? > TopMemoryContext: 40960 total in 4 blocks; 8632 free (10 chunks); 32328 used > SPI Plan: 3072 total in 2 blocks; 1728 free (0 chunks); 1344 used > TopTransactionContext: 534765568 total in 74 blocks; 2144 free (68 chunks);

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
Just as a reminder, this is an 8.0.0 install, so if you think this might have been fixed in later sub-releases, plesae let me know and I'll upgrade/test again ... On Thu, 11 Aug 2005, Marc G. Fournier wrote: On Thu, 11 Aug 2005, Marc G. Fournier wrote: On Thu, 11 Aug 2005, Tom Lane wrote:

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
On Thu, 11 Aug 2005, Marc G. Fournier wrote: 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. No

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Tom Lane
"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 po

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > On Thu, 11 Aug 2005, Tom Lane wrote: >> 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

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
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

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
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 tha

Re: [BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Tom Lane
"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

[BUGS] [8.0.0] out of memory on large UPDATE

2005-08-11 Thread Marc G. Fournier
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. 0.000u 0.022s 2:41:14.76 0.0% 88+66k 12+0io 19pf+0w And the server is running: PostgreSQL 8.0.0 on i386-portbld-freebsd4.10, compil