Hi all,
I Got more improvements using vacuumdb utility and the size of my database
was decreasead from 1.3gb to 900mb.
Only one thing is not right yeat. My procedure perform others 7
subprocedures and with reimported database, it's took about 5 minutes to
complete. With old vacuumed database, the same process took 20minutes, it's
much better than the 4 hours before, but there is little diference.
Now, i have scheduled the vacuumdb --analyze once a day and
vacuumdb --analyze --all --full once a week, i think this is enough.
Now i'll check for reindexes tables and i'll perform analyze in each query
in procedure.
When i get more results, i post here.
Thanks a Lot
Rodrigo Moreno