Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 8CF13633096 for ; Sun, 20 Jun 2010 05:23:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 19449-03 for ; Sun, 20 Jun 2010 08:23:41 +0000 (UTC) X-Greylist: delayed 08:29:21.96822 by SQLgrey-1.7.6 Received: from homiemail-a3.g.dreamhost.com (caiajhbdcbef.dreamhost.com [208.97.132.145]) by mail.postgresql.org (Postfix) with ESMTP id 71A7863271D for ; Sun, 20 Jun 2010 05:23:42 -0300 (ADT) Received: from [192.168.178.20] (host-88-217-185-158.customer.m-online.net [88.217.185.158]) (Authenticated sender: murrayc@murrayc.com) by homiemail-a3.g.dreamhost.com (Postfix) with ESMTPA id 9169628405E; Sun, 20 Jun 2010 01:23:39 -0700 (PDT) Subject: Re: Initial database size on disk From: Murray Cumming To: Simon Riggs Cc: pgsql-interfaces@postgresql.org In-Reply-To: <1276993324.23257.102118.camel@ebony> References: <1276991654.17689.2.camel@murrayc-x61> <1276993324.23257.102118.camel@ebony> Content-Type: text/plain; charset="UTF-8" Date: Sun, 20 Jun 2010 10:23:34 +0200 Message-ID: <1277022214.421.1.camel@murrayc-x61> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201006/8 X-Sequence-Number: 6909 On Sun, 2010-06-20 at 01:22 +0100, Simon Riggs wrote: > On Sun, 2010-06-20 at 01:54 +0200, Murray Cumming wrote: > > > When using the initdb command-line utility to create a new PostgreSQL > > database cluster, is there any way to specify the starting size used on > > disk? By default it seems to take around 38MB. > > Why do you want to do that? Make it bigger, or smaller? I would like to make it smaller. I use PostgreSQL in my Glom application to host (initially) small amounts of data, starting a PostgreSQL instance automatically whenever the data must be opened. -- murrayc@murrayc.com www.murrayc.com www.openismus.com