Re: [PERFORM] Massive update, memory usage

2010-10-28 Thread Trenta sis
Well, I have solved executing with more RAM, and then works correctly Thanks 2010/10/28 Cédric Villemain > 2010/10/28 Trenta sis : > > > > > > There are about 100.000 inserts and 30 updates. Without transaction > it > > seems that works, but with a transacti

[PERFORM] Massive update, memory usage

2010-10-28 Thread Trenta sis
? thanks 2010/10/28 Craig Ringer On 10/28/2010 02:38 AM, Trenta sis wrote: > >> >> Hi, >> >> I have a Linux Server (Debian) with Postgres 8.3 and I have problems >> with a massive update, about 40 updates/inserts. >> If I execute about 10 it seems all o

[PERFORM] Massive update, memory usage

2010-10-27 Thread Trenta sis
Hi, I have a Linux Server (Debian) with Postgres 8.3 and I have problems with a massive update, about 40 updates/inserts. If I execute about 10 it seems all ok, but when I execute 40, I have the same problem with or without a transaction (I need to do with a transaction) increase memor