elein wrote: Hi Elein, > autovacuum does special stuff when there is an approaching transaction > wrap around. > We have a lot of transactions and wrap around as much as once a week. > > We'd like to invoke vacuum to do the special stuff explicitly so that we > can do it during lower traffic times. Like weekends rather than > weekdays. What release are we talking about? 8.1, 8.2 and 8.3 are all different in this regard. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general