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?