Saurabh wrote:
> wal_buffers = 5MB
As as already been suggested, use 16MB (or if the version you're
using supports it, the default of -1);
> autovacuum = off
If the only activity while this is off is a bulk load, that might be
OK, but be sure *not* to leave this off. You will almost certainly
regret very much later. Your tables will tend to bloat and slowly
get very slow and very big. At that point it will be much more
painful to do aggressive maintenance to clean things up. If you
think you have some particular reason to turn it off, please discuss
it here -- you might have better options.
-Kevin