| From: | GB Clark <postgres(at)vsservices(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Nice Oracle tuning article |
| Date: | 2002-02-25 18:02:17 |
| Message-ID: | 20020225120217.06a22d68.postgres@vsservices.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Sun, 24 Feb 2002 20:42:15 -0500 (EST)
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)VSServices(dot)COM | General Geek
CTHULU for President - Why choose the lesser of two evils?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-02-25 18:02:56 | Re: A minor bug and a complaint |
| Previous Message | Matteo Beccati | 2002-02-25 17:42:34 | Timestamp output |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-02-25 18:30:10 | Re: More time zones |
| Previous Message | Tom Lane | 2002-02-25 17:24:20 | Re: missing foreign key fails silently using COPY |