phpgroupware-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [phpGroupWare-users] Postgres: poor performance...


From: Benoit Hamet
Subject: Re: [phpGroupWare-users] Postgres: poor performance...
Date: Tue, 11 Sep 2007 15:21:43 +0200
User-agent: IceDove 1.5.0.12 (X11/20070607)

Hi Marco,

Marco Gaiarin a écrit :
> Mandi! Chris Weiss
>   In chel di` si favelave...
> 
>> how often do you vacuum the database?
> 
> Default debian configuration, autovacuuming enabled.
> 
> I've see this message friday some minutes before leaving work, so i've
> explicitly waited the weekend, but this morning nothing changed.
> Still 2-3 secs to displat 25 addresses. ;(
> 
> I'm using also LDAP (account storage, not addressbook!), could be this the
> bottlenek? There's some way i can measue delays?
it could be the bottelneck. LDAP Is like another DB Engine, if you don't
build indexes, you will drop performances ... take a look in the
slapd.conf man pages, look for loglevel option, there's a level which
trace index misses -> add them to your slapd.conf, rebuilt them using
slapindex (IIRC), and you should be ok.

Regards.

Caeies.




reply via email to

[Prev in Thread] Current Thread [Next in Thread]