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/

Reply via email to