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