Re: Sanity check requested - Mailing list pgsql-performance

From Oliver Scheit
Subject Re: Sanity check requested
Date
Msg-id B7397E6AC70AB1418180FA3480B9365556A52A@deun2kex01.REALGARANT.DE
Whole thread Raw
In response to Sanity check requested  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-performance
>> > 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 by date:

Previous
From: Vincent van Leeuwen
Date:
Subject: Re: Sanity check requested
Next
From:
Date:
Subject: Re: Yet another slow join query.. [ SOLVED ]