Re: Postgres: poor performance...

"Chris Weiss" <[email protected]>
Newsgroups gmane.comp.web.phpgroupware.general
Message-ID <[email protected]> 
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, 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?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.