Re: 3WARE Card performance boost?

От: Vivek Khera
Тема: Re: 3WARE Card performance boost?
Дата: ,
Msg-id: 32A67C0F-9726-4E79-AA12-B1D2AD83748A@khera.org
(см: обсуждение, исходный текст)
Ответ на: 3WARE Card performance boost?  ("Benjamin Arai")
Список: pgsql-performance

Скрыть дерево обсуждения

3WARE Card performance boost?  ("Benjamin Arai", )
 Re: 3WARE Card performance boost?  ("Joshua D. Drake", )
  Re: 3WARE Card performance boost?  (Alex Turner, )
  Re: 3WARE Card performance boost?  ("Jim C. Nasby", )
 Re: 3WARE Card performance boost?  ("Benjamin Arai", )
  Re: 3WARE Card performance boost?  (Joost Kraaijeveld, )
 Re: 3WARE Card performance boost?  (Alex Turner, )
 Re: 3WARE Card performance boost?  (William Yu, )
  Re: 3WARE Card performance boost?  ("Steinar H. Gunderson", )
   Re: 3WARE Card performance boost?  (William Yu, )
  Re: 3WARE Card performance boost?  (Alex Turner, )
 Re: 3WARE Card performance boost?  (Vivek Khera, )

On Jan 18, 2006, at 1:09 PM, Benjamin Arai wrote:

> Obviously, I have done this to improve write performance for the
> update each
> week.  My question is if I install a 3ware or similar card to
> replace my

I'll bet that if you increase your checkpoint_segments (and
corresponding timeout value) to something in the 10's or higher it
will help you a lot.



В списке pgsql-performance по дате сообщения:

От: Bruce Momjian
Дата:
Сообщение: Re: Autovacuum / full vacuum (off-topic?)
От: K C Lau
Дата:
Сообщение: SELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX