Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id B00A96325AC for ; Sat, 19 Jun 2010 21:22:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 98283-01 for ; Sun, 20 Jun 2010 00:22:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149081.authsmtp.net (outmail149081.authsmtp.net [62.13.149.81]) by mail.postgresql.org (Postfix) with ESMTP id 7B0B4632392 for ; Sat, 19 Jun 2010 21:22:12 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt2.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o5K0M8Sv090529; Sun, 20 Jun 2010 00:22:08 GMT Received: from [192.168.0.2] (88-110-191-21.dynamic.dsl.as9105.com [88.110.191.21]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id o5K0M5tt087129; Sun, 20 Jun 2010 01:22:05 +0100 (BST) Subject: Re: Initial database size on disk From: Simon Riggs To: Murray Cumming Cc: pgsql-interfaces@postgresql.org In-Reply-To: <1276991654.17689.2.camel@murrayc-x61> References: <1276991654.17689.2.camel@murrayc-x61> Content-Type: text/plain Date: Sun, 20 Jun 2010 01:22:04 +0100 Message-Id: <1276993324.23257.102118.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Server-Quench: db732297-7c01-11df-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagVbZ0xf HGQLWlREUFx7W2F/ awwfZQ1DY0tOQQRj UVZLQ01XHAJ3AVJe A2UeLxw2MwVOf39y bAhjWXhbEhAockV/ QEdTCGpVZWZ9aWFL Bl1RcFEGbQNKfB1D bll4XHYMaStlM3Bw LC4VAx0LExx0BR9g CiALLE4TSEJDEjcg ThoLBjhnBkwXSm00 KVQqK0UfdAAI X-Authentic-SMTP: 61633235383639.1014:706/Kp X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201006/7 X-Sequence-Number: 6908 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? -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services