Re: Massive update, memory usage

Поиск
Список
Период
Сортировка
От Emanuele Bracci Poste
Тема Re: Massive update, memory usage
Дата
Msg-id 353FA609-C68A-44C4-9267-2891D2F0E6CD@poste.it
обсуждение исходный текст
Ответ на Re: Massive update, memory usage  (Trenta sis <trenta.sis@gmail.com>)
Список pgsql-performance
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

#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; width: 240px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 13px;}

В списке pgsql-performance по дате отправления:

Предыдущее
От: Trenta sis
Дата:
Сообщение: Re: Massive update, memory usage
Следующее
От: "Igor Neyman"
Дата:
Сообщение: Re: partitioning question 1