Hi, My postgresql configuration is max_locks_per_transaction = 256 max_connections = 200 shared_buffers = 6000max_fsm_pages = 200000 max_fsm_relations = 1500
My serversers total RAM=32GBStill I am not able to insert more than 10million records, its taking lot of time. It also gives hint to increse max_fsm_pages. So Please suggest me how do I adjust above parameters to avoid errors and to increase postgres speed performance?
Thanks , Amar