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@xxxxxxxxxxxxxx > [mailto:pgsql-php-owner@xxxxxxxxxxxxxx]On Behalf Of > valeria@xxxxxxxxxxxxxxxxxx > Sent: Wednesday, 17 April 2002 11:27 PM > To: pgsql-php@xxxxxxxxxxxxxx > 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 >
