The single most important question - have you logged into your database and
run:
vacuum analyze;
Recently?
You can use the vacuumdb commandline utility to do this once a day from a
cron job.
Chris
> -----Original Message-----
> From: pgsql-php-owner@postgresql.org
> [mailto:pgsql-php-owner@postgresql.org]On Behalf Of
> valeria@saolucas-se.com.br
> Sent: Wednesday, 17 April 2002 11:27 PM
> To: pgsql-php@postgresql.org
> Subject: [PHP] PERFORMANCE
>
>
> Hello,
>
> I´m new on the list and I´ve been using postgres on a production
> environment for 3 months. My team and I have developed a system for a
> Hospital in which we work with php-postgres-linux. In the begining
> everything was fine. As soon as the tables grew larger, we´ve begun to
> experience an enormous performance fall. By now, the system is almost
> crawling. We´ve already made all possible changes on hardware, which is a
> COMPAQ ML370, scsi, with 2 PIII 800 and 768 MB RAM. The only test we will
> still do is to change the scsi controller for an ultra 160. On the other
> hand, searching the archives of this list, I´ve collected many complaints
> about degradation of performance of insert/update, as tables are
> populated. My question is:
>
> "IS THERE ANYONE THAT CANT GIVE US SOME HOPE TO PERSIST ON POSTGRES OR IS
> THIS A LOST BATLE?"
>
> If so, we need some advice to change this situation, instead of changing
> database or bying a supercomputer?
>
> Thanks
>
> Paulo
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>