469,090 Members | 1,143 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

partitioning

On small productions systems, single disk, etc, how do you guys like to
partition the system? Postgres dirs also?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
1 1357
On Fri, 24 Oct 2003, Dennis Gearon wrote:
On small productions systems, single disk, etc, how do you guys like to
partition the system? Postgres dirs also?


I'll assume you're talking Linux, but other flavors of unix would be
similar:

On small systems, I generally put a pair IDE drives in and mirror
everything from one to the other (they're cheap, and mirror sets have
saved my butt on many occasions.)

/ <- 250 Meg (including /boot
/usr <- 1 to 4 gigs
/tmp <- 1 gig
/var <- 1 gig
/db <- where pgsql data lives, as big as it needs to be.
/www <- where apache data lives, as big as it needs to be.
/usr/local OR /opt depending on OS <- ~ 1 to 4 gig

The main reason for doing this kind of thing is so that if some process
goes nuts and fills up your logs (/var) temp directory (/tmp) or database
partition (/db) it won't bring everything else to its knees, just the area
it affected.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

18 posts views Thread by Jeff Boes | last post: by
7 posts views Thread by Jane | last post: by
2 posts views Thread by jorge | last post: by
reply views Thread by Robert Klemme | last post: by
10 posts views Thread by shsandeep | last post: by
8 posts views Thread by mitek | last post: by
15 posts views Thread by Piero 'Giops' Giorgi | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.