From: Emanuele Bracci Poste <emanuele.bracci@poste.it>
To: Trenta sis <trenta.sis@gmail.com>
Cc: Cédric Villemain <cedric.villemain.debian@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Massive update, memory usage
Date: Fri, 29 Oct 2010 00:07:29 +0200
Message-ID: <353FA609-C68A-44C4-9267-2891D2F0E6CD@poste.it> (raw)
In-Reply-To: <AANLkTi=A6q_29k-N4BM37Vkchfnas5HoXxQB=BTe0UFX@mail.gmail.com>
References: <AANLkTimt5WsyiXZFqNkFRWK330JxUEy-288qaS2KX+9f@mail.gmail.com>
<AANLkTiniK=6ZLjiQJYHnRSO_zsePYjqGf=cm733JG+3R@mail.gmail.com>
<4CC8B4B1.1070208@postnewspapers.com.au>
<AANLkTi=40Mvys44Bc6neSnSr9Bym5mXj8KqNfV6aR3dr@mail.gmail.com>
<AANLkTinwbru42SL-Mp6-eD7SL_hLw-ZfjZ3vwuA==-fj@mail.gmail.com>
<AANLkTincFPZVNFMto5AFPYOZm7vUxbrjBN-hT+cCZYRW@mail.gmail.com>
<AANLkTi=A6q_29k-N4BM37Vkchfnas5HoXxQB=BTe0UFX@mail.gmail.com>
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
>
> Thanks
>
>
>
> 2010/10/28 Cédric Villemain <cedric.villemain.debian@gmail.com>
> 2010/10/28 Trenta sis <trenta.sis@gmail.com>:
> >
> >
> > 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?
>
> You should post your queries, and tables definitions involved.
>
> >
> > thanks
> >
> > 2010/10/28 Craig Ringer <craig@postnewspapers.com.au>
> >>
> >> 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
> >
> >
> >
>
>
>
> --
> Cédric Villemain 2ndQuadrant
> http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: emanuele.bracci@poste.it, trenta.sis@gmail.com, cedric.villemain.debian@gmail.com
Subject: Re: Massive update, memory usage
In-Reply-To: <353FA609-C68A-44C4-9267-2891D2F0E6CD@poste.it>
References: <AANLkTimt5WsyiXZFqNkFRWK330JxUEy-288qaS2KX+9f@mail.gmail.com> <AANLkTiniK=6ZLjiQJYHnRSO_zsePYjqGf=cm733JG+3R@mail.gmail.com> <4CC8B4B1.1070208@postnewspapers.com.au> <AANLkTi=40Mvys44Bc6neSnSr9Bym5mXj8KqNfV6aR3dr@mail.gmail.com> <AANLkTinwbru42SL-Mp6-eD7SL_hLw-ZfjZ3vwuA==-fj@mail.gmail.com> <AANLkTincFPZVNFMto5AFPYOZm7vUxbrjBN-hT+cCZYRW@mail.gmail.com> <AANLkTi=A6q_29k-N4BM37Vkchfnas5HoXxQB=BTe0UFX@mail.gmail.com> <353FA609-C68A-44C4-9267-2891D2F0E6CD@poste.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox