Re: Sanity check requested

From: "Oliver Scheit" <oliver(dot)scheit(at)REALGARANT(dot)DE>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Sanity check requested
Date: 2003-07-18 16:42:26
Message-ID: B7397E6AC70AB1418180FA3480B9365556A52A@deun2kex01.REALGARANT.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-performance by date

  From Date Subject
Next Message mallah 2003-07-18 17:41:10 Re: Yet another slow join query.. [ SOLVED ]
Previous Message Vincent van Leeuwen 2003-07-18 16:28:55 Re: Sanity check requested