Hi Matthew, Would rebooting the server interfere with the work of pg_autovacuum? I imagine that pg_autovacuum would loose the information that it gathered prior to the reboot. Would not pg_autovacuum need to gather data about the database again before it can judge if it should analyze/vacuum a table of the database? -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Matthew T. O'Connor Sent: Thursday, November 10, 2005 3:44 PM To: Carlos Oliva Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Performance of autovacuum and full vacuum of database Carlos Oliva wrote: > Thank you for your response Matthew. Currently I run pg_autovacuum with the > following scripts. > su -l postgres -c "pg_autovacuum -D -U postgres > /dev/null 2>&1"& > > Do you suggest that I could change it to something like the following: > su -l postgres -c "pg_autovacuum -d2 -D -U postgres > /tmp/vacuum.log 2>&1"& Yes exactly, and if you find that pg_autovacuum is never or not often enough firing off vacuum comands, then you will need to play with the threshold settings. The default thresholds for pg_autovacuum are too conservative for most people, so you may very well have to do this. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
