Postgres Pro
Downloads
Home   >   mailing lists

Re: two disks - best way to use them? - Mailing list pgsql-performance

From Olleg Samoylov
Subject Re: two disks - best way to use them?
Date
Msg-id dn1gv1$1erb$1@news.hub.org
Whole thread Raw
In response to two disks - best way to use them?  ("Rick Schumeyer" <rschumeyer@ieee.org>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Olleg Samoylov
Date:
Subject: BLCKSZ
Next
From: Tom Lane
Date:
Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0