ideal filesystem layout - Mailing list pgsql-novice

From danix@cloud9.net (danix)
Subject ideal filesystem layout
Date
Msg-id 20020530035809.534A42AA07@earl-grey.cloud9.net
Whole thread Raw
Responses Re: ideal filesystem layout  ("Joshua b. Jore" <josh@greentechnologist.org>)
List pgsql-novice
I've been asked to assist a DBA with setting up a postgres system.
I cannot seem to find any documentation on how to set up the filesystem
in an ideal fashion, other than the usual installation in /usr/local/pgsql.

This is likely a FAQ, so point me to it if it is, but otherwise, how would you
set up a box for a largish database (around 2Gb)?  I have 4x18Gb drives to
play with, most likely as a single Raid5 50Gb volume.

Would you have a partition just for transaction logs?  How would you slice
up the box as a dedicated pgsql server?  The o/s is redhat.

Thanks!

pgsql-novice by date:

Previous
From: Ron Johnson
Date:
Subject: [Fwd: Re: CPU types and queries...]
Next
From: Ludwig Lim
Date:
Subject: PL/PgSQL Cursors vs. Pl/SQL Cursors