Very cool, that worked wonders for me, back to about the same speed(maybe a
little slower but it should speed up over time as you said). Also, it
halved the physical size of the database. for my ~130 users it took
~20minutes to run VACUUM FULL ANALYZE;
What is required to make it VACUUM ANALYZE every night?
Thanks for all the help!
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 21:07:17 -0500
Eric Hiller wrote:
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?
Under VACUUM FULL, it's very slow. But I don't know that it's unusable.
I don't have what you would call a lot but it took maybe 10 minutes. I
have a relatively slow system.
But since FULL locks the table, it will have an effect. You might have to
take dbmail down while you do the largest tables. But I would start with a
VACUUM ANALYZE and make certain that the autovacuum process is running.
Only after that would I consider going to a VACUUM FULL. It will probably
require a short system outage to do the message related tables but not the
users or other smaller tables.
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________________________________________________
Stay up-to-date with your friends through the Windows Live Spaces friends
list.
http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mk
