Re: Postgres: poor performance...

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.