Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi

From: 德哥 <digoal(at)126(dot)com>
To: "Andres Freund" <andres(at)2ndquadrant(dot)com>
Cc: "Heikki Linnakangas" <hlinnakangas(at)vmware(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi
Date: 2014-04-16 11:38:25
Message-ID: 6dab83fa.29c12.1456a54abc8.Coremail.digoal@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

HI,
thanks
I use async commit in this test environment.

--
公益是一辈子的事,I'm Digoal,Just Do It.

在 2014-04-16 19:34:38，"Andres Freund" <andres(at)2ndquadrant(dot)com> 写道：
>On 2014-04-16 19:31:33 +0800, 德哥 wrote:
>> CONFIGURE = '... '--with-wal-blocksize=64' '--with-blocksize=32' ...'
>
>Independent of problems around this that probably should be fixed, I
>think it's a pretty bad idea to use such a large wal blocksize. That'll
>cause a fair amount of write amplification at commits and such.
>It might work out well if you only doing bulk loading, but still..
>
>Greetings,
>
>Andres Freund
>
>--
> Andres Freund http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2014-04-16 15:29:01 Re: BUG #9749: ERROR: unexpected classid 3600
Previous Message Andres Freund 2014-04-16 11:34:38 Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi