Hi, I'm using james 1.0 with jdbc-based spool/mailboxes/etc. with postgresql 7.4.2 as the RDBMS. Everything works fine.
As you may know, postgresql does not fully reclaim disk space for deleted tuples in a relation unless you execute a "vacuum full" command. As you might expect, this operation requires an exclusive lock on the entire table in question. Tables like "spool" and "inbox" quickly become physically huge but very sparse. I want to schedule a cron job to periodically run "vacuum full" on the james database. Will james cope gracefully with the jdbc exceptions if/when these tables are locked? (In particular, will delivery/spooling/processing be deferred--will I lose emails?) If not, is it possible/advisable to suspend james' operation programmatically? Thanks, Steve -- Steve Linabery, sysadmin/developer World Cycling Productions --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
