X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A7785D6819 for ; Wed, 2 Nov 2005 23:47:57 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63335-03 for ; Thu, 3 Nov 2005 03:47:53 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id B4254D6817 for ; Wed, 2 Nov 2005 23:47:55 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jA33m0dh017604; Wed, 2 Nov 2005 22:48:00 -0500 (EST) To: dave.bath@unix.net Cc: pgsql-admin@postgresql.org Subject: Re: Pre-allocation of space: a business rationale In-reply-to: <200511031427.10391.dave.bath@unix.net> References: <21438.1130817553@sss.pgh.pa.us> <200511021400.05346.xzilla@users.sourceforge.net> <200511031427.10391.dave.bath@unix.net> Comments: In-reply-to "Bath, David" message dated "Thu, 03 Nov 2005 14:27:09 +1100" Date: Wed, 02 Nov 2005 22:48:00 -0500 Message-ID: <17603.1130989680@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.006 required=5 tests=[AWL=0.006] X-Spam-Score: 0.006 X-Spam-Level: X-Archive-Number: 200511/22 X-Sequence-Number: 19395 "Bath, David" writes: > C) I want to avoid the possibility of uncontrolled growth of luser data > blowing disk leading to stoppage of 24x7 data. You put the luser data and the critical data into separate tablespaces that are in separate partitions (filesystems). End of problem ... (And no, I don't believe in having Postgres reinvent filesystem-level functionality. If you didn't set up appropriate hard partitions, consider a loopback filesystem for your tablespace.) regards, tom lane