472,096 Members | 1,591 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,096 software developers and data experts.

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 1399
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.