Re: Massive table (500M rows) update nightmare

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Massive table (500M rows) update nightmare
Дата
Msg-id dcc563d11001071740q572cdae2re410788fe790dbf6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Massive table (500M rows) update nightmare  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Ответы Re: Massive table (500M rows) update nightmare  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
New server to improve performance on our large and busy DB - advice?  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Re: Massive table (500M rows) update nightmare  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Список pgsql-performance
Дерево обсуждения 
On Thu, Jan 7, 2010 at 2:48 PM, Carlo Stonebanks
<stonec.register@sympatico.ca> wrote:
> Doing the updates in smaller chunks resolved these apparent freezes - or,
> more specifically, when the application DID freeze, it didn't do it for more
> than 30 seconds. In all likelyhood, this is the OS and the DB thrashing.

It might well be checkpoints.  Have you tried cranking up checkpoint
segments to something like 100 or more and seeing how it behaves then?

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Air-traffic benchmark
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: "large" spam tables and performance: postgres memory parameters