pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <jim@nasby.net>
To: Nikola Radakovic <achillea@hi.t-com.hr>
Cc: pgsql-admin@postgresql.org
Subject: Re: Memory space
Date: Wed, 8 Nov 2006 00:21:34 -0600
Message-ID: <20061108062134.GX90133@nasby.net> (raw)
In-Reply-To: <1162833406.13539.6.camel@localhost.localdomain>
References: <1162833406.13539.6.camel@localhost.localdomain>

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)



view thread (2+ messages)

Message-ID: <20061108062134.GX90133@nasby.net>
Permalink:  ../20061108062134.GX90133@nasby.net/
Also on:    postgresql.org/message-id/20061108062134.GX90133@nasby.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jim@nasby.net, achillea@hi.t-com.hr
  Subject: Re: Memory space
  In-Reply-To: <20061108062134.GX90133@nasby.net>
  References: <1162833406.13539.6.camel@localhost.localdomain> <20061108062134.GX90133@nasby.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox