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@2ndquadrant.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
