On Tue, Feb 14, 2012 at 10:53 PM, Jan-Frode Myklebust <janfr...@tanso.net>wrote:
> 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..
>
> No, my database not yet too busy. I do not see much high load either.
however my
/var/lib/pgsql/data/postgresql.conf max connection is set to 100
and changed the PERFORK to 70
however, I have tons of error in /var/log/sogo/sogo
Could not bind to the LDAP server ldap.hi.is (389) using the bind DN:
uid=test,ou=People,dc=test,dc=com
but again I can access sogo and all. I am not sure about this error. It
could be thunderbird or iphone are trying to synchronize the event and
somehow sogo could not bind on that particular synchonization. Do you know
how to debug this ?
Thanks
K
-jf
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
--
users@sogo.nu
https://inverse.ca/sogo/lists
