X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E34659DCAEE for ; Tue, 6 Dec 2005 05:39:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71477-08 for ; Tue, 6 Dec 2005 05:39:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id BCB719DCC83 for ; Tue, 6 Dec 2005 05:39:18 -0400 (AST) Received: from campbell-lange.net (campbell-lange.net [217.147.82.41]) by svr2.postgresql.org (Postfix) with ESMTP id B2CBBF0B32 for ; Tue, 6 Dec 2005 09:39:20 +0000 (GMT) Received: from host-83-146-33-145.bulldogdsl.com ([83.146.33.145] helo=orchard) by localhost.localdomain with esmtpa (Exim 4.54) id 1EjZIE-0000mD-Vk for pgsql-performance@postgresql.org; Tue, 06 Dec 2005 09:39:27 +0000 Received: from rory by orchard with local (Exim 4.54) id 1EjZH8-0008DP-B9 for pgsql-performance@postgresql.org; Tue, 06 Dec 2005 09:38:18 +0000 Date: Tue, 6 Dec 2005 09:38:18 +0000 From: Rory Campbell-Lange To: pgsql-performance@postgresql.org Subject: LVM and Postgres Message-ID: <20051206093818.GE6708@campbell-lange.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.332 required=5 tests=[RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.332 X-Spam-Level: * X-Archive-Number: 200512/148 X-Sequence-Number: 15969 I need to slice up a web server's disk space to provide space for postgres and storing binaries such as images and sound files. I'm thinking of using logical volume management (LVM) to help manage the amount of space I use between postgres and the data volumes. The server has a 250GB RAID10 (LSI 320-I + BBU) volume which I am thinking of slicing up in the following way (Linux 2.6 kernel): / : ext3 : 47GB (root, home etc) /boot : ext3 : 1GB /tmp : ext2 : 2GB /usr : ext3 : 4GB /var : ext3 : 6GB ----------------------- 60GB VG : 190GB approx ----------------------- Initially divided so: /data : ext3 : 90GB /postgres : xfs : 40GB This gives me left over space of roughly 60GB to extend into on the volume group, which I can balance between the /data and /postgres logical volumes as needed. Are there any major pitfalls to this approach? Thanks, Rory -- Rory Campbell-Lange