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

2007-09-12 Thread Marco Gaiarin
Mandi! Benoit Hamet In chel di` si favelave... > 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

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

2007-09-11 Thread Marco Gaiarin
Mandi! Benoit Hamet In chel di` si favelave... > 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 ...but it is nurmal that an addressbook access throw massive LDAP query to accounts? > slapd.conf man pa

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

2007-09-11 Thread Benoit Hamet
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, b

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

2007-09-10 Thread Marco Gaiarin
Mandi! Dave Hall In chel di` si favelave... > 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. I'm a

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

2007-09-10 Thread 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 >

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

2007-09-10 Thread 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 d

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

2007-09-07 Thread Chris Weiss
On 9/7/07, Marco Gaiarin <[EMAIL PROTECTED]> wrote: > > I've just write about this some month ago, but now i've some more > things to say. > > I've just installed my new server an Acer Altos G450, with two-core > Xeon at 2GHz and 2 Gig of DDR2 RAM. > I've also moved from debian sarge (php4, postgre

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

2007-09-07 Thread Marco Gaiarin
I've just write about this some month ago, but now i've some more things to say. I've just installed my new server an Acer Altos G450, with two-core Xeon at 2GHz and 2 Gig of DDR2 RAM. I've also moved from debian sarge (php4, postgres 7.4) to debian etch (php5, postgres 8.1). To to an install as