The problem is the PG team are looking at making autovac compulsory (ie. You can't turn it off). I don't know when, might be in 8.2, but I know the issue has been discussed on the lists before. Andy -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Joshua D. Drake Sent: Wednesday, 12 April, 2006 12:51 am To: Chris Hoover Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Autovacuum ideas > This is one thing that is preventing me from turning on autovacuun,. > However, due to the activity on them, they really need to be vacuumed > daily. It would be nice to be able to tell autovacuum to run, but > have a way to tell it to always sleep during these hours ( i.e. 7am to > 5pm daily). Has there been any thought into a feature like this? Well... just turn off autovac and then use vacuumdb during off hours via cron. Joshua D. Drake > > Thanks, > > Chris -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend !DSPAM:14,443c41f433694226768114!
