Re: Initial database size on disk

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
Cc: Murray Cumming <murrayc(at)murrayc(dot)com>, "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Initial database size on disk
Date: 2010-06-20 15:11:29
Message-ID: 24982.1277046689@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Devrim GUNDUZ <devrim(at)gunduz(dot)org> writes:
> 20.Haz.2010 tarihinde 02:54 saatinde, Murray Cumming <murrayc(at)murrayc(dot)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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Satoshi Nagayasu 2010-06-22 07:57:12 SQLDA question
Previous Message Devrim GUNDUZ 2010-06-20 12:59:08 Re: Initial database size on disk