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
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 |