How to get fastness on query? How to get results quickly?
By inceasing work_mem we can acheive fastness on query results
show work_mem;
set work_mem to 1000MB
Increasing work mem to specific user
Alter user <user> set work_mem to '1000MB'
How to increase read performance?
By making below changes in config file we can achieve better read performance
fsynce=false
increase work_mem
increase shared_bufferes
create indexs
How to increase write performance?
By making below changes in config file we can achieve better write performance
decrease checkpoint_timeout
increase shared_buffers
increase wal_buffers
increase work_mem
increase maintenance_work_mem
also see below
No comments:
Post a Comment