Kelvin, My intention to keep autovacuum as off is bulk loading only. I was thinking after bullk load I will change it. I changed wal_buffer from 5MB to 16MB but I got same performance that I got with 5MB (even less). Thanks, Saurabh -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance