Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id 7C9FD9F9425 for ; Wed, 8 Nov 2006 02:21:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 46543-08 for ; Wed, 8 Nov 2006 02:21:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 317779F93C9 for ; Wed, 8 Nov 2006 02:21:36 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 1DD2B5645D; Wed, 8 Nov 2006 00:21:36 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Wed, 8 Nov 2006 00:21:34 -0600 Date: Wed, 8 Nov 2006 00:21:34 -0600 From: "Jim C. Nasby" To: Nikola Radakovic Cc: pgsql-admin@postgresql.org Subject: Re: Memory space Message-ID: <20061108062134.GX90133@nasby.net> References: <1162833406.13539.6.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1162833406.13539.6.camel@localhost.localdomain> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061108:achillea@hi.t-com.hr::9Tu1ieLamCG2+TGc:00000000000000000 0000000000000000000000001WGg X-Hashcash: 1:20:061108:pgsql-admin@postgresql.org::Qr0m/EsqhUD7b9kd:00000000000 0000000000000000000000000f21 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/67 X-Sequence-Number: 23594 On Mon, Nov 06, 2006 at 11:16:46AM -0600, Nikola Radakovic wrote: > Dear community, > > First of all, I am completely new on this mailing list. > I have read tons of tutorials, but I can't find how to set up > further thing.I know how to add database for each user, but how to > achieve in Postgres 8.1 how big assigned database should be on server > machine? > > For instance: > I want that database cash for user1 occupies 500Mb disk space. > database calendar for user2 occupies 100Mb > etc... Unlike some other databases, PostgreSQL doesn't deal with size limits. Unless you really want to limit the size of each database there's nothing to worry about. If you do want to limit the size, your only option is to create a cluster for each user and let the OS quota limit size (though many versions of PostgreSQL don't react too kindly to running out of space). A third option is to use one cluster, but create each database with it's own tablespace, and only give users access to their tablespaces. It's not quite as fool-proof as multiple clusters, but it's a lot easier on system resources. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)