Re: Hardware performance

От: Andrew Sullivan
Тема: Re: Hardware performance
Дата: ,
Msg-id: 20030717184152.GG479@libertyrms.info
(см: обсуждение, исходный текст)
Ответ на: Re: Hardware performance  (Joe Conway)
Список: pgsql-performance

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

Hardware performance  ("Balazs Wellisch", )
 Re: Hardware performance  ("Roman Fail", )
  Re: Hardware performance  (Ron Johnson, )
 Re: Hardware performance  (Joe Conway, )
  Re: Hardware performance  (Hannu Krosing, )
   Re: Hardware performance  (Joe Conway, )
    Re: Hardware performance  (Adam Witney, )
     Re: Hardware performance  (Joe Conway, )
      Re: Hardware performance  (Adam Witney, )
       Re: Hardware performance  (Joe Conway, )
       Re: Hardware performance  (Jord Tanner, )
       Re: Hardware performance  (Robert Creager, )
    Re: Hardware performance  (Andrew Sullivan, )
 Re: Hardware performance  (Vincent van Leeuwen, )
 Re: Hardware performance  (Jean-Luc Lachance, )
  Re: Hardware performance  (Joe Conway, )
 Re: Hardware performance  (Jean-Luc Lachance, )
 Re: Hardware performance  ("Magnus Hagander", )
  Re: Hardware performance  (Ron Johnson, )
 Re: Hardware performance  ("Magnus Hagander", )

On Thu, Jul 17, 2003 at 07:57:53AM -0700, Joe Conway wrote:
>
> As I said, I've never personally found it necessary to move WAL off to a
> different physical drive. What do you think is the best configuration

On our Solaris test boxes (where, alas, we do not have the luxury of
1/2 TB external RAID boxes :-( ), putting WAL on a disk of its own
yielded something like 30% improvement in throughput on high
transaciton volumes.  So it's definitely important in some cases.

A

----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<>                              M2P 2A8
                                         +1 416 646 3304 x110



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

От: Josh Berkus
Дата:
Сообщение: Table clustering -- useful, or not?
От: Robert Creager
Дата:
Сообщение: Re: Hardware performance