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

[Dave Hall]

Hi Marco,

On Mon, 2007-09-10 at 09:33 +0200, Marco Gaiarin wrote:
> 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's also possible that we could have better indexes on the tables,
> > anyone with pgsql care to take a look?

It is a geenral problem with the addressbook.  There was a script
floating around at some point to add the indexes to the contacts tables
for MySQL.  I tried googling for it and couldn't find it.  I know it
does really boost performance.

Adding indexes to any field which is used in a where clause should help
performance.  I know caching data is important and it is something we
should look at more in HEAD.

Cheers

Dave