Re: Postgresql Performance
| From: | Matt M. | Date: | Fri, 20 Aug 2004 01:48:25 +0000 |
| Subject: | Re: Postgresql Performance | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35809@lists.php.net to get a copy of this message | ||
On Thu, 19 Aug 2004 18:12:16 -0500, Norma Ramirez
<norma.ramirez@tecnosoft.com.co> wrote:
> Hi all, I have a problem with a small software in Postresql, through the
> time the database become slower and slower so, quick solution: pg_dump,
> dropdb, createdb and pg_dump again but this software is becoming important
> and such procedure is not a very reliable way to improve the performance, I
> have tried with some commands like Vacuum and Analyze but non of this seems
> to work as good as drop database and create again.
>
> Can any one give me some advices?
1. vacuum and analyze would be my suggestions but you say you have tried that.
2. maybe upgrade your postgres version
3. try a postgres mailing list