Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5057A632B8E for ; Sun, 20 Jun 2010 12:11:43 -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 34186-08 for ; Sun, 20 Jun 2010 15:11:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 885DE63275D for ; Sun, 20 Jun 2010 12:11:34 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o5KFBTSc024983; Sun, 20 Jun 2010 11:11:29 -0400 (EDT) To: Devrim GUNDUZ cc: Murray Cumming , "pgsql-interfaces@postgresql.org" Subject: Re: Initial database size on disk In-reply-to: References: <1276991654.17689.2.camel@murrayc-x61> Comments: In-reply-to Devrim GUNDUZ message dated "Sun, 20 Jun 2010 15:59:08 +0300" Date: Sun, 20 Jun 2010 11:11:29 -0400 Message-ID: <24982.1277046689@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/11 X-Sequence-Number: 6912 Devrim GUNDUZ writes: > 20.Haz.2010 tarihinde 02:54 saatinde, Murray Cumming >> şunları yazdı: >> 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. > You can recompile PostgreSQL with a smaller wal size, which will > reduce initial size a bit. I am not sure about the side effects though. There might be some value in that if you expect your database instances will always be small and low in write volume. Otherwise you're just shooting yourself in the foot for a transitory gain. regards, tom lane