Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am running into problems where Postgres autovacuum processes are interfering with the overall performance of my database. It is making my select, insert, and update queries slower than usual. What are some settings, and optimization strategies that will make autovacuum have less of an impact on my database performance?

Is there a way to make it not consume as much memory/CPU so that client queries can run more efficiently?

share|improve this question
3  
Please supply your exact PostgreSQL version (select version()) and platform, along with some info on the hardware - CPU, disks, raid controller if any, etc. You should also include info on how autovacuum is configured right now. select name, boot_val, reset_val from pg_settings where name like '%autovacuum%'; Edit your question to add this info and comment here when done. –  Craig Ringer Aug 29 '13 at 2:22
add comment

1 Answer

From: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server :

"The answer to almost all vacuuming problems is to vacuum more often, not less, so that each individual vacuum operation has less to clean up."

Some basic tuning suggestions at: http://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM

(Auto)Vaccum details: http://wiki.postgresql.org/wiki/Introduction_to_VACUUM,_ANALYZE,_EXPLAIN,_and_COUNT

share|improve this answer
    
Please fix your last two links above - and, when done, you could also add the main points of those pages here (like you did with the first one). –  dezso Sep 2 '13 at 5:22
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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