I changed the configuration in postgresql.conf. Following are the changed parameters:
shared_buffers = 1GB maintenance_work_mem = 50MB checkpoint_segments = 64 wal_buffers = 5MB autovacuum = off Insert the records in the database and got a very good performance it is increased by 6 times. Can you please tell me the purpose of shared_buffer and maintenance_work_mem parameter? Thanks, Saurabh -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
