Re: [PHP-DB] Postgresql Performance

2004-08-19 Thread Matt M.
On Thu, 19 Aug 2004 18:12:16 -0500, Norma Ramirez
<[EMAIL PROTECTED]> 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Postgresql Performance

2004-08-19 Thread Norma Ramirez
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?

Thanks

Norma R

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php