From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | <valeria(at)saolucas-se(dot)com(dot)br>, <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: PERFORMANCE |
Date: | 2002-04-18 01:33:50 |
Message-ID: | GNELIHDDFBOCMGBFGEFOIECOCCAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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(at)postgresql(dot)org
> [mailto:pgsql-php-owner(at)postgresql(dot)org]On Behalf Of
> valeria(at)saolucas-se(dot)com(dot)br
> Sent: Wednesday, 17 April 2002 11:27 PM
> To: pgsql-php(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Michel POURE | 2002-04-18 08:17:56 | Re: PERFORMANCE |
Previous Message | Dan Wilson | 2002-04-17 21:52:34 | Re: |