Thread: ideal filesystem layout

ideal filesystem layout

From
danix@cloud9.net (danix)
Date:
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!

Re: ideal filesystem layout

From
"Joshua b. Jore"
Date:
While I qualify for running a very small scale installation that doesn't
have such problems my first wish would be to separate the transaction logs
onto a separate SCSI drive from the data. Go check out
http://techdocs.postgresql.org. There are some excellent articles on just
this sort of thing by Robert Mello and others. You'll be better served by
reading that first and *then* posting if it doesn't answer your questions.

Joshua b. Jore ; http://www.greentechnologist.org ; 10012 11010 11022
10202 1012 2122 11020 10202 10202 11002 1020 1012 11102 11102 11102 1201
11001 11002 10211 11020 10202 10202 11002 11021 1201 11010 11020 10211

On Wed, 29 May 2002, danix wrote:

> 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!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>