Re: Initial database size on disk - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Initial database size on disk
Date
Msg-id 24982.1277046689@sss.pgh.pa.us
Whole thread Raw
In response to Re: Initial database size on disk  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: Initial database size on disk
Next
From: Satoshi Nagayasu
Date:
Subject: SQLDA question