Re: Sanity check requested

От: Vincent van Leeuwen
Тема: Re: Sanity check requested
Дата: ,
Msg-id: 20030718162854.GW21071@md2.mediadesign.nl
(см: обсуждение, исходный текст)
Ответ на: Re: Sanity check requested  ("Oliver Scheit")
Список: 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", )

On 2003-07-18 18:20:55 +0200, Oliver Scheit wrote:
> > Be sure to mount noatime
>
> I did "chattr -R +A /var/lib/pgsql/data"
> that should do the trick as well or am I wrong?
>

According to the man page it gives the same effect. There are a few things you
should consider though:
- new files won't be created with the same options (I think), so you'll have
to run this command as a daily cronjob or something to that effect
- chattr is probably more filesystem-specific than a noatime mount, although
this isn't a problem on ext[23] ofcourse

Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/


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

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