Postgresql Performance
| From: | Norma Ramirez | Date: | Thu, 19 Aug 2004 23:12:16 +0000 |
| Subject: | Postgresql Performance | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35808@lists.php.net to get a copy of this message | ||
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