Re: File systems (RE: Sanity check requested)

От: Tom Lane
Тема: Re: File systems (RE: Sanity check requested)
Дата: ,
Msg-id: 5893.1058564959@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: File systems (RE: Sanity check requested)  ("Nick Fankhauser")
Список: pgsql-performance

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

Sanity check requested  ("Nick Fankhauser", )
 Re: Sanity check requested  ("Shridhar Daithankar", )
  Re: Sanity check requested  ("Nick Fankhauser", )
   Re: Sanity check requested  (Josh Berkus, )
    Re: Sanity check requested  ("Nick Fankhauser", )
     Re: Sanity check requested  (Joe Conway, )
   Re: Sanity check requested  ("Shridhar Daithankar", )
    Clearing rows periodically  (Martin Foster, )
     Re: Clearing rows periodically  (Paul Thomas, )
     Re: Clearing rows periodically  (Andrew Sullivan, )
     Re: Clearing rows periodically  (Tom Lane, )
    Re: Sanity check requested  (Ang Chin Han, )
     File systems (RE: Sanity check requested)  ("Nick Fankhauser", )
      Re: File systems (RE: Sanity check requested)  (Tom Lane, )
     Re: Sanity check requested  ("scott.marlowe", )
   Re: Sanity check requested  (Vincent van Leeuwen, )
    Re: Sanity check requested  ("Nick Fankhauser", )
     Re: Sanity check requested  (Josh Berkus, )
     Re: Sanity check requested  (Rod Taylor, )
 Re: Sanity check requested  ("Oliver Scheit", )
  Re: Sanity check requested  (Vincent van Leeuwen, )
 Re: Sanity check requested  ("Oliver Scheit", )

"Nick Fankhauser" <> writes:
> I'm departing in three ways from the simple IDE
> model that (I presume) the default random page cost of 4 is based on- The
> disks are SCSI & RAID and the FS would be different.

Actually, the default 4 is based on experiments I did quite awhile back
on HPUX (with a SCSI disk) and Linux (with an IDE disk, and a different
filesystem).  I didn't see too much difference between 'em.  RAID might
alter the equation, or not.

            regards, tom lane


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

От: Tom Lane
Дата:
Сообщение: Re: File systems (RE: Sanity check requested)
От: Matthew Hixson
Дата:
Сообщение: storing files in Postgres