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
