On Tue, Feb 14, 2012 at 10:39:30PM +0000, Khapare Joshi wrote:
>
> server, any sogo configuration parameter ? postgres indexing ?
Is your postgres database busy? We were struggeling with high cpu usage
on our databaseserver recently, and it turned out it was a problem with
the session table growing and growing. We now run a daily deletion of
all rows older than 24 hours:
DELETE from sogo_sessions_folder WHERE extract('epoch' from
current_timestamp)-c_lastseen > 86400;
I believe there's also an index fix for this table in v1.3.12..
-jf
--
[email protected]
https://inverse.ca/sogo/lists
