[Top][All Lists]
[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.