Re: performance on new linux box

От: David Boreham
Тема: Re: performance on new linux box
Дата: ,
Msg-id: 4C364671.7010109@boreham.org
(см: обсуждение, исходный текст)
Ответ на: Re: performance on new linux box  (<>)
Список: pgsql-performance

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

performance on new linux box  (Ryan Wexler, )
 Re: performance on new linux box  (Tom Lane, )
 Re: performance on new linux box  (Rob Wultsch, )
 Re: performance on new linux box  (Andy Colson, )
  Re: performance on new linux box  (Eliot Gable, )
   Re: performance on new linux box  ("Kevin Grittner", )
    Re: performance on new linux box  (Eliot Gable, )
     Re: performance on new linux box  ("Kevin Grittner", )
      Re: performance on new linux box  (Ryan Wexler, )
       Re: performance on new linux box  ("Joshua D. Drake", )
       Re: performance on new linux boxeradmin(11983)i: STATEMENT: update license set expires= '2010-06-15' where lic  (John Rouillard, )
       Re: performance on new linux box  (Craig James, )
       Re: performance on new linux box  (Russell Smith, )
        Re: performance on new linux box  (Samuel Gendler, )
         Re: performance on new linux box  (Ryan Wexler, )
          Re: performance on new linux box  (Greg Smith, )
          Re: performance on new linux box  (Andy Colson, )
       Re: performance on new linux box  ("Joshua D. Drake", )
 Re: performance on new linux box  ("Pierre C", )
 Fwd: performance on new linux box  (Ryan Wexler, )
  Re: performance on new linux box  (Jochen Erwied, )
   Re: performance on new linux box  (Ryan Wexler, )
    Re: performance on new linux box  ("Kevin Grittner", )
    Re: performance on new linux box  (Jochen Erwied, )
     Re: performance on new linux box  (Ryan Wexler, )
      Re: performance on new linux box  (Ben Chobot, )
      Re: performance on new linux box  ("Kevin Grittner", )
       Re: performance on new linux box  (Ryan Wexler, )
        Re: performance on new linux box  (David Boreham, )
        Re: performance on new linux box  ("Kevin Grittner", )
        Re: performance on new linux box  (Craig James, )
         Re: performance on new linux box  (<>, )
          Re: performance on new linux box  (Craig James, )
           Re: performance on new linux box  (Scott Carey, )
            Re: performance on new linux box  (Ben Chobot, )
             Re: performance on new linux box  (Scott Carey, )
              Re: performance on new linux box  (Ben Chobot, )
               Re: performance on new linux box  (Ryan Wexler, )
                Re: performance on new linux box  (Ben Chobot, )
                 Re: performance on new linux box  (Craig Ringer, )
               Re: performance on new linux box  (Scott Carey, )
                Re: performance on new linux box  (Ben Chobot, )
                Re: performance on new linux box  (Greg Smith, )
              Re: performance on new linux box  (Scott Marlowe, )
               Re: performance on new linux box  (Scott Carey, )
               Re: performance on new linux box  (Craig Ringer, )
            Re: performance on new linux box  (Ryan Wexler, )
          Re: performance on new linux box  (David Boreham, )
   Re: performance on new linux box  (Ryan Wexler, )
    Re: performance on new linux box  (Jochen Erwied, )
 Re: performance on new linux box  (Ben Chobot, )
  Re: performance on new linux box  ("Pierre C", )

On 7/8/2010 3:18 PM,  wrote:
> How does the linux machine know that there is a BBU installed and to
> change its behavior or change the behavior of Postgres? I am
> experiencing performance issues, not with searching but more with IO.
>
It doesn't change its behavior at all. It's in the business of writing
stuff to a file and waiting until that stuff has been put on the disk
(it wants a durable write). What the write buffer/cache does is to
inform the OS, and hence PG, that the write has been done when in fact
it hasn't (yet). So the change in behavior is only to the extent that
the application doesn't spend as much time waiting.




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

От: Craig Ringer
Дата:
Сообщение: Re: Need help in performance tuning.
От: Samuel Gendler
Дата:
Сообщение: Re: Need help in performance tuning.