Good point - I should have said that in order to reduce the size of my bloated DB (at 14Gb) I put the FULL in and will remove for normal production :-)
Cheers Kevin -----Original Message----- From: Larry Rosenman [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 September 2006 9:16 a.m. To: Sartorelli, Kevin; 'Tom Kistner' Cc: [email protected] Subject: RE: [exim] Exilog database size The full causes an EXCLUSIVE lock, and therefore may cause the inserts to block. With a LAZY (I.E. Non-Full) Vacuum, we don't grab the exclusive lock, and the free space Is added to the Free-Space Map (FSM). The PGDG (PostgreSQL Global Development Group) recommends lazy vacuums if at all possible. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [email protected] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -----Original Message----- From: Sartorelli, Kevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 4:13 PM To: Larry Rosenman; Tom Kistner Cc: [email protected] Subject: RE: [exim] Exilog database size Thanks for the advice. I have patched exilog_sql.pm as below (and added a FULL to reduce the DB size) and re-ran the clean up. All is looking much better :-) Cheers Kevin -----Original Message----- From: Larry Rosenman [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 September 2006 1:43 a.m. To: 'Tom Kistner' Cc: Sartorelli, Kevin; [email protected] Subject: RE: [exim] Exilog database size Tom, yes, the patch I have in the FreeBSD port is to change (for PostgreSQL) the OPTIMIZE TABLE to VACUUM ANALYZE. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [email protected] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -----Original Message----- From: Tom Kistner [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 2:31 AM To: Larry Rosenman Cc: 'Sartorelli, Kevin'; [email protected] Subject: Re: [exim] Exilog database size Larry Rosenman wrote: > What are your FSM settings for PostgreSQL? Did you update the cleanup > routine to actually Do the vacuum? (I'm the FreeBSD port maintainer, > and the patch is in the FreeBSD ports collection). Larry is probably right. At least I don't remember doing anything related to a "Vacuum" in the postgres SQL stubs (maybe this is the equivalent of MySQLs "optimize table"?). /tom -- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
