Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 242541337B88 for ; Thu, 28 Oct 2010 19:28:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 62369-07 for ; Thu, 28 Oct 2010 22:28:05 +0000 (UTC) X-Greylist: delayed 00:20:31.017573 by SQLgrey-1.7.6 Received: from relay-pt2.poste.it (relay-pt2.poste.it [62.241.5.253]) by mail.postgresql.org (Postfix) with ESMTP id 9E7EE1337B3E for ; Thu, 28 Oct 2010 19:28:05 -0300 (ADT) Received: from [172.16.33.53] (184.0.50.66) by relay-pt2.poste.it (8.5.121.01) (authenticated as emanuele.bracci@poste.it) id 4CC8AF71001576C9; Fri, 29 Oct 2010 00:07:33 +0200 Subject: Re: Massive update, memory usage Mime-Version: 1.0 (Apple Message framework v1081) Content-Type: multipart/alternative; boundary=Apple-Mail-139-758804233 From: Emanuele Bracci Poste In-Reply-To: Date: Fri, 29 Oct 2010 00:07:29 +0200 Cc: =?iso-8859-1?Q?C=E9dric_Villemain?= , pgsql-performance@postgresql.org Message-Id: <353FA609-C68A-44C4-9267-2891D2F0E6CD@poste.it> References: <4CC8B4B1.1070208@postnewspapers.com.au> To: Trenta sis X-Mailer: Apple Mail (2.1081) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.609 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201010/566 X-Sequence-Number: 40984 --Apple-Mail-139-758804233 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 Scusa, scadenze a parte, ma non vi =E8 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 >=20 > Thanks >=20 >=20 >=20 > 2010/10/28 C=E9dric Villemain > 2010/10/28 Trenta sis : > > > > > > There are about 100.000 inserts and 300000 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 configuration or it is correct? >=20 > You should post your queries, and tables definitions involved. >=20 > > > > 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 400000 updates/inserts. > >>> If I execute about 100000 it seems all ok, but when I execute = 400000, I > >>> have the same problem with or without a transaction (I need to do = with a > >>> transaction) increase memory usage and disk usage. > >>> With a execution of 400.000 inserts/update server begin woring = well, but > >>> after 100 seconds of executions increase usage of RAM, and then = Swap and > >>> finally all RAM and swap are used and execution can't finish. > >> > >> Do you have lots of triggers on the table? Or foreign key = relationships > >> that're DEFERRABLE ? > >> > >> -- > >> Craig Ringer > > > > > > >=20 >=20 >=20 > -- > C=E9dric Villemain 2ndQuadrant > http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et = Support >=20 --Apple-Mail-139-758804233 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1
Well, I = have solved executing with more RAM, and then works = correctly

Thanks





= --Apple-Mail-139-758804233--