I read up a bit about this command and it seems that while it is running the
database is unusable. About how long did this take for you when you ran it?
Thanks,
Eric
From: Tom Allison <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <dbmail@dbmail.org>
To: DBMail mailinglist <dbmail@dbmail.org>
Subject: Re: [Dbmail] Extremely slow performance with 2.2.1 + postgresql
Date: Sun, 26 Nov 2006 13:49:14 -0500
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.
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________________________________________________
MSN Shopping has everything on your holiday list. Get expert picks by style,
age, and price. Try it!
http://shopping.msn.com/content/shp/?ctId=8000,ptnrid=176,ptnrdata=200601&tcode=wlmtagline
