How to set the these parameters on postgresql.conf ?
What I should consider while setting them?
What should I monitor?

#vacuum_cost_delay = 0ms                
#vacuum_cost_page_hit = 1                
#vacuum_cost_page_miss = 10             
#vacuum_cost_page_dirty = 20            
#vacuum_cost_limit = 200    

is there any good tutorial or example?

  • hello questioner, do you have an answer? – ProgramCpp Aug 28 at 17:28

The postgres docs are the best place to start

| improve this answer | |

This really depends on your system, and what kind of load it has to handle. Got 100 SSD drives on a SAN with 8Gigs of battery backed cache? Got a single 5400RPM SATA drive?

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.