From: Olleg Samoylov <olleg_s@mail.ru>
To: pgsql-performance@postgresql.org
Subject: Re: two disks - best way to use them?
Date: Mon, 05 Dec 2005 16:56:55 +0300
Message-ID: <dn1gv1$1erb$1@news.hub.org> (raw)
In-Reply-To: <00fb01c5f772$59471410$0200a8c0@dell8200>
References: <00fb01c5f772$59471410$0200a8c0@dell8200>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: olleg_s@mail.ru
Subject: Re: two disks - best way to use them?
In-Reply-To: <dn1gv1$1erb$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox