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: [EMAIL PROTECTED]:~$ 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 _______________________________________________ phpGroupWare-users mailing list [email protected] http://lists.gnu.org/mailman/listinfo/phpgroupware-users
