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

[Marco Gaiarin]

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?

Mine:

address@hidden:~$ echo '\di' | psql phpgroupwaresv | grep contact
 public | phpgw_contact_addr_pkey             | indice | phpgroupware | 
phpgw_contact_addr
 public | phpgw_contact_addr_type_pkey        | indice | phpgroupware | 
phpgw_contact_addr_type
 public | phpgw_contact_comm_descr_pkey       | indice | phpgroupware | 
phpgw_contact_comm_descr
 public | phpgw_contact_comm_pkey             | indice | phpgroupware | 
phpgw_contact_comm
 public | phpgw_contact_comm_type_pkey        | indice | phpgroupware | 
phpgw_contact_comm_type
 public | phpgw_contact_note_pkey             | indice | phpgroupware | 
phpgw_contact_note
 public | phpgw_contact_note_type_pkey        | indice | phpgroupware | 
phpgw_contact_note_type
 public | phpgw_contact_org_person_pkey       | indice | phpgroupware | 
phpgw_contact_org_person
 public | phpgw_contact_others_pkey           | indice | phpgroupware | 
phpgw_contact_others
 public | phpgw_contact_pkey                  | indice | phpgroupware | 
phpgw_contact
 public | phpgw_contact_types_pkey            | indice | phpgroupware | 
phpgw_contact_types


-- 
dott. Marco Gaiarin                                 GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  marco.gaiarin(at)sv.lnf.it      tel +39-0434-842711  fax +39-0434-842797