Re: [BUGS] Out of memory while UPDATE some_table ... FROM some_view (8.0 beta5)

2004-11-30 Thread Tom Lane
Robert Osowiecki <[EMAIL PROTECTED]> writes: > While doing some large update on table with over 1 million records: > HashBatchContext: 360701952 total in 52 blocks; 7158680 free (140 > chunks); 353543272 used Evidently this hashtable got out of hand :-( > Query is EXPLAIN-ed as follows: > Hash

[BUGS] Out of memory while UPDATE some_table ... FROM some_view (8.0 beta5)

2004-11-30 Thread Robert Osowiecki
While doing some large update on table with over 1 million records: update tordspecif set sp_vat=vv_vat, sp_vat_opis=vv_vat_opis, sp_ar_sww=vv_sww from varticlevat where sp_az_artsize=vv_artsize PostgreSQL 8.0.0beta5 on i686-pc-linux-gnu, compiled by GCC 2.96 reported