agora inbox for pgsql-interfaces@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Devrim GUNDUZ <devrim@gunduz.org>
Cc: Murray Cumming <murrayc@murrayc.com>
Cc: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Subject: Re: Initial database size on disk
Date: Sun, 20 Jun 2010 11:11:29 -0400
Message-ID: <24982.1277046689@sss.pgh.pa.us> (raw)
In-Reply-To: <B44FE489-07DA-41C7-9FE5-CB06F6B3112E@gunduz.org>
References: <1276991654.17689.2.camel@murrayc-x61>
<B44FE489-07DA-41C7-9FE5-CB06F6B3112E@gunduz.org>
Devrim GUNDUZ <devrim@gunduz.org> writes:
> 20.Haz.2010 tarihinde 02:54 saatinde, Murray Cumming <murrayc@murrayc.com
>>> ş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
view thread (6+ messages)
Message-ID: <24982.1277046689@sss.pgh.pa.us>
Permalink: ../24982.1277046689@sss.pgh.pa.us/
Also on: postgresql.org/message-id/24982.1277046689@sss.pgh.pa.us
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, devrim@gunduz.org, murrayc@murrayc.com
Subject: Re: Initial database size on disk
In-Reply-To: <24982.1277046689@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox