Re: two disks - best way to use them?

From: Olleg Samoylov <olleg_s(at)mail(dot)ru>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: two disks - best way to use them?
Date: 2005-12-05 13:56:55
Message-ID: dn1gv1$1erb$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Rick Schumeyer wrote:
> 1) the input data file
> 2) the pg table
> 3) the WAL

And journal of file system, especially if you not set "noatime" mount
option. WAL and file system journal like to make sync.

IMHO: on first disk (raid mirror:)) I place /, pg_table and file system
journal from second disk. On second /var and pg tables. Thus first disc
is synced time to time, second not.
--
Olleg Samoylov

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-12-05 14:32:53 Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Previous Message Olleg Samoylov 2005-12-05 13:47:31 BLCKSZ