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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
