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: ler@???
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
-----Original Message-----
From: Tom Kistner [mailto:tom@duncanthrax.net]
Sent: Wednesday, September 20, 2006 2:31 AM
To: Larry Rosenman
Cc: 'Sartorelli, Kevin'; exim-users@???
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
