Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id 547B89FB1ED for ; Mon, 6 Nov 2006 17:01:29 -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 36029-09 for ; Mon, 6 Nov 2006 17:01:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from boston.agmednet.com (boston.agmednet.com [64.156.16.20]) by postgresql.org (Postfix) with ESMTP id 2BEB09FA497 for ; Mon, 6 Nov 2006 17:01:26 -0400 (AST) Received: from 70.91.219.145 ([70.91.219.145]) by agmednet-dc.boston.agmednet.local ([10.10.39.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 6 Nov 2006 20:55:26 +0000 Received: from localhost.localdomain by boston.agmednet.com; 06 Nov 2006 16:01:19 -0500 Subject: Re: Database size From: Mike Goldner To: Nikola Radakovic Cc: pgsql-admin@postgresql.org In-Reply-To: <1162846082.16473.5.camel@localhost.localdomain> References: <1162846082.16473.5.camel@localhost.localdomain> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Mon, 06 Nov 2006 16:01:19 -0500 Message-Id: <1162846879.5202.34.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-27.rhel4.6) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/33 X-Sequence-Number: 23560 Nikola, I'm not exactly sure what you are asking. The size of the database is usually determined by the amount of data stored and not determined beforehand. Are you refering of "tablespaces", as other DBMSs use them? If so, Postgres has a tablespace command, but it simply points to a filesystem location. There is no "size" specified. The size of the database is simply limited by the available filesystem capacity (I suppose there may be some restrictions at the high-end). Mike On Mon, 2006-11-06 at 14:48 -0600, Nikola Radakovic wrote: > Dear community, > > I would be very grateful if someone could answer me, > where to find instructions how to set the size ( in megabytes ) for > particular database. > > > best regards, > N.Radakovic > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Mike Goldner Vice President Networks and Technology AG Mednet, Inc. The Pilot House Lewis Wharf Boston, MA 02110 617.854.3225 (office) 617.909.3009 (mobile)