Eric Hiller wrote:
I ran dbmail-util -ay, is this what you mean? Or something else? I am
running postgresql 7.4 and would be very interested in the steps taken
to full-vacuum analyze. Also what steps did you take to "tune" the
database?
Thanks very much for the help,
Eric
I am on 8.1 so I don't know that everything will apply.
But there are a lot of settings in the postgres.conf file that you need to
consider for the tuning of the database. Far more than I should probably go
into there on the dbmailing list. But none of this should vary between versions
of dbmail.
As for the vacuum analyze..
as dbmail or postgres user: 'VACUUM FULL ANALYZE' will do a complete cleanup of
the database in terms of discarded rows and analyze the data to optimize the
query execution. This ANALYZE should be done periodically as it can greatly
improve performance.
Under 8.1 and maybe 7.x there is a autovacuum deamon that does this for you.
But if you have very large amounts of data to vacuum then it might pass because
of the potential for performance impact.
As far as I know, the -a option under dbmail-utils doesn't to an ANALYZE. But
I'm rather new.
Considering you had to rebuild some database tables when you migrated the
versions, I think you should take the time out to make sure that the database
has been 'VACUUM FULL ANALYZE'. You might also check the database to make sure
that the indexes are not damaged. But I believe the previous command will tell
you this.
