Re: Sanity check requested

От: Rod Taylor
Тема: Re: Sanity check requested
Дата: ,
Msg-id: 1058555567.31093.22.camel@jester
(см: обсуждение, исходный текст)
Ответ на: 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", )

> ...About one year ago I considered moving to a journaling file system, but
> opted not to because it seems like that's what WAL does for us already. How
> does putting a journaling file system under it add more reliability?

WAL only works if the WAL files are actually written to disk and can be
read off it again.  Ext2 has a number of deficiencies which can cause
problems with this basic operation (inode corruptions, etc).  Journaling
does not directly help.

Вложения

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

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