Re: Sanity check requested

Поиск
Список
Период
Сортировка
Искать
От
Oliver Scheit
Тема
Re: Sanity check requested
Дата
Msg-id
B7397E6AC70AB1418180FA3480B9365556A52A@deun2kex01.REALGARANT.DE
Список
Дерево обсуждения
Sanity check requested "Nick Fankhauser" <nickf@ontko.com>
Re: Sanity check requested "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: Sanity check requested "Nick Fankhauser" <nickf@ontko.com>
Re: Sanity check requested Josh Berkus <josh@agliodbs.com>
Re: Sanity check requested "Nick Fankhauser" <nickf@ontko.com>
Re: Sanity check requested Joe Conway <mail@joeconway.com>
Re: Sanity check requested Vincent van Leeuwen <pgsql.spam@vinz.nl>
Re: Sanity check requested "Nick Fankhauser" <nickf@ontko.com>
Re: Sanity check requested Rod Taylor <rbt@rbt.ca>
Re: Sanity check requested Josh Berkus <josh@agliodbs.com>
Re: Sanity check requested "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Clearing rows periodically Martin Foster <martin@ethereal-realms.org>
Re: Clearing rows periodically Paul Thomas <paul@tmsl.demon.co.uk>
Re: Clearing rows periodically Andrew Sullivan <andrew@libertyrms.info>
Re: Clearing rows periodically Tom Lane <tgl@sss.pgh.pa.us>
Re: Sanity check requested Ang Chin Han <angch@bytecraft.com.my>
File systems (RE: Sanity check requested) "Nick Fankhauser" <nickf@ontko.com>
Re: File systems (RE: Sanity check requested) Tom Lane <tgl@sss.pgh.pa.us>
Re: Sanity check requested "scott.marlowe" <scott.marlowe@ihs.com>
>> > 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

This would be a really interesting point to know.
I will look into this.

I think the advantage of "chattr" is that the last access time
is still available for the rest of the filesystem.
(Of course you could have your own filesystem just for the
database stuff, in this case the advantage would be obsolete)

regards,
Oli
В списке pgsql-performance по дате отправления
От: Vincent van Leeuwen
Дата:
Сообщение: Re: Sanity check requested
От:
Дата:
FAQ