Re: [PERFORM] Massive update, memory usage

2010-10-28 Thread Emanuele Bracci Poste
Scusa, scadenze a parte, ma non vi è sembrato il caso di chiedere a chi sta gestendo il progetto prima di rimuovere una risorsa? Grazie comunque. Emanuele Il giorno 28/ott/2010, alle ore 23.48, Trenta sis ha scritto: > Well, I have solved executing with more RAM, and then works correctly > > Th

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 transaction no. Witt about only 300.000

Re: [PERFORM] Massive update, memory usage

2010-10-28 Thread 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 transaction no. Witt about only 300.000 updates > it seems that can finish correctly, but last 20% is slow because is using > swap... > > Any tunning to do in this

Re: [PERFORM] Massive update, memory usage

2010-10-27 Thread 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 ok, but when I execute 40, I have the same problem with or without a transaction (I

Re: [PERFORM] Massive update, memory usage

2010-10-27 Thread Andreas Kretschmer
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. Updates or Inserts? > If I execute about 10 it seems all ok, but when I execute 40, I have > the same problem with or without a tr