Re: [HACKERS] Nice Oracle tuning article

On Sun, 24 Feb 2002 20:42:15 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us> wrote:

> This is a nice article about tuning Oracle for Linux:
>
>     http://www.linuxjournal.com//article.php?sid=5840
>
> It would be nice to have some of these numbers for PostgreSQL.  Does
> no-access-time affect performance?  What about the other parameters?
Bruce,

I know for a fact that under FreeBSD setting noatime in /etc/fstab helps both
PostgreSQL and Apache.  Otherwise the system has to update whichever file has been
touched even though on 95% of the files we don't care.  Maybe not quite as a big win
as Apache, but it does help PostgreSQL.

GB



--
GB Clark II             | Roaming FreeBSD Admin
gclarkii@VSServices.COM | General Geek
           CTHULU for President - Why choose the lesser of two evils?