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

On 2014-04-16 19:31:33 +0800, =E5=BE=B7=E5=93=A5 wrote:
> CONFIGURE =3D '... '--with-wal-blocksize=3D64' '--with-blocksize=3D32' =
...'

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

--=20
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services