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

[Chris Weiss]

On 9/7/07, Marco Gaiarin <address@hidden> 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, postgres 7.4) to debian etch
> (php5, postgres 8.1).
>
> I've 1800+ adresses (not millions!) in addressbook, and still if i
> select al the addresses (25 per page) i have to wait a second to have
> the page drawn (top icon bar, left menu) and roughly two/three seconds
> to have 25 addresses displayed.

how often do you vacuum the database?

it's also possible that we could have better indexes on the tables,
anyone with pgsql care to take a look?