From: | Trenta sis <trenta(dot)sis(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Massive update, memory usage |
Date: | 2010-10-28 08:16:20 |
Message-ID: | AANLkTinwbru42SL-Mp6-eD7SL_hLw-ZfjZ3vwuA==-fj@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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?
thanks
2010/10/28 Craig Ringer <craig(at)postnewspapers(dot)com(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Pierre C | 2010-10-28 09:33:16 | Re: Select count(*), the sequel |
Previous Message | Pavel Stehule | 2010-10-28 04:26:08 | Re: Postgres insert performance and storage requirement compared to Oracle |