On Thu, 19 Aug 2004 18:12:16 -0500, Norma Ramirez <norma.ramirez@xxxxxxxxxxxxxxxx> 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
