Re: 2.2.2 slow

I ran dbmail-util -cy and it helped some, but not much.  I
clocked the 
loading a single message about 2 paragraphs in length, no
attachments, at 
around 5 seconds both before and after dbmail-util -cy.

Everything here is local, so it isnt connection speed
slowing it down to my 
knowledge.


>From: "Aaron Stone" <aaronserendipity.cx>
>Reply-To: DBMail mailinglist <dbmaildbmail.org>
>To: <jessekci.net>, "DBMail
mailinglist" <dbmaildbmail.org>
>Subject: Re: [Dbmail] 2.2.2 slow
>Date: Wed, 4 Apr 2007 21:35:58 -0000
>
>SVN should be stable at this time, though we have a few
bugs outstanding
>that have not been completely identified and resolved.
Your mileage may
>vary.
>
>But that's sort of beside the point -- pegging the cpu
at 100% for 2
>seconds upon each message delivery is not a
"performance issue," it's a
>disaster! Something on Eric's machine is not right, and
hopefully we'll be
>able to help identify and resolve the issue with him.
>
>Aaron
>
>On Wed, Apr 4, 2007, Jesse Norell <jessekci.net> said:
>
> > There have been some changes to improve speed
since 2.2.2 though,
> > haven't there?  From irc conversation, another
pertinent question is, is
> > 2.2 svn stable right now?  I know there were a run
of issues a week or
> > two back, but have the major issues cleared?  If
so, Eric could probably
> > try latest svn and report back on speed
differences.
> >
> > Jesse
> >
> >
> > On Wed, 2007-04-04 at 20:33 +0000, Aaron Stone
wrote:
> >> That's not DBMail being slow, it's your
database. Run top during 
>message
> >> delivery and you'll see who's eating the cpu.
Most likely you need to
> >> vacuum/optimize/analyze your tables.
dbmail-util -c will do this for 
>you.
> >>
> >> Aaron
> >>
> >> On Wed, Apr 4, 2007, Eric Hiller
<mrraptor98hotmail.com> said:
> >>
> >> > I have been running 2.2.2 and it has been
very stable.  Ran it as 
>soon as it
> >> > came out and it worked on a test machine.
 Only thing is it is MUCH 
>slower
> >> > than 2.0.10. Any mail request and the sql
server cpu is pegged at 
>100% for
> >> > 2+ seconds.  Is this issue resolved, or
will it be in 2.2.5?
> >> >
> >> > Thanks much for dbmail it really has been
great,
> >> > Eric
> >
> > --
> > Jesse Norell - jessekci.net
> > Kentec Communications, Inc.
> >
> > _______________________________________________
> > DBmail mailing list
> > DBmaildbmail.org
> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
>
>--
>
>
>
>_______________________________________________
>DBmail mailing list
>DBmaildbmail.org
>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

____________________________________________________________
_____
Exercise your brain! Try Flexicon. 
http://games.msn.com/en/flexicon
/default.htm?icid=flexicon_hmemailtaglineapril07

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Try
vacuumdb -f -U <username> -d <dbname>

When this command is run, the database is locked.


Eric Hiller wrote:
> I ran dbmail-util -cy and it helped some, but not much.
 I clocked the 
> loading a single message about 2 paragraphs in length,
no attachments, 
> at around 5 seconds both before and after dbmail-util
-cy.
> 
> Everything here is local, so it isnt connection speed
slowing it down to 
> my knowledge.
> 
> 
>> From: "Aaron Stone" <aaronserendipity.cx>
>> Reply-To: DBMail mailinglist <dbmaildbmail.org>
>> To: <jessekci.net>, "DBMail
mailinglist" <dbmaildbmail.org>
>> Subject: Re: [Dbmail] 2.2.2 slow
>> Date: Wed, 4 Apr 2007 21:35:58 -0000
>>
>> SVN should be stable at this time, though we have a
few bugs outstanding
>> that have not been completely identified and
resolved. Your mileage may
>> vary.
>>
>> But that's sort of beside the point -- pegging the
cpu at 100% for 2
>> seconds upon each message delivery is not a
"performance issue," it's a
>> disaster! Something on Eric's machine is not right,
and hopefully 
>> we'll be
>> able to help identify and resolve the issue with
him.
>>
>> Aaron
>>
>> On Wed, Apr 4, 2007, Jesse Norell <jessekci.net> said:
>>
>> > There have been some changes to improve speed
since 2.2.2 though,
>> > haven't there?  From irc conversation, another
pertinent question 
>> is, is
>> > 2.2 svn stable right now?  I know there were a
run of issues a week or
>> > two back, but have the major issues cleared? 
If so, Eric could 
>> probably
>> > try latest svn and report back on speed
differences.
>> >
>> > Jesse
>> >
>> >
>> > On Wed, 2007-04-04 at 20:33 +0000, Aaron Stone
wrote:
>> >> That's not DBMail being slow, it's your
database. Run top during 
>> message
>> >> delivery and you'll see who's eating the
cpu. Most likely you need to
>> >> vacuum/optimize/analyze your tables.
dbmail-util -c will do this 
>> for you.
>> >>
>> >> Aaron
>> >>
>> >> On Wed, Apr 4, 2007, Eric Hiller
<mrraptor98hotmail.com> said:
>> >>
>> >> > I have been running 2.2.2 and it has
been very stable.  Ran it as 
>> soon as it
>> >> > came out and it worked on a test
machine.  Only thing is it is 
>> MUCH slower
>> >> > than 2.0.10. Any mail request and the
sql server cpu is pegged at 
>> 100% for
>> >> > 2+ seconds.  Is this issue resolved,
or will it be in 2.2.5?
>> >> >
>> >> > Thanks much for dbmail it really has
been great,
>> >> > Eric
>> >
>> > --
>> > Jesse Norell - jessekci.net
>> > Kentec Communications, Inc.
>> >
>> >
_______________________________________________
>> > DBmail mailing list
>> > DBmaildbmail.org
>> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>> >
>>
>> -- 
>>
>>
>>
>> _______________________________________________
>> DBmail mailing list
>> DBmaildbmail.org
>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 
>
____________________________________________________________
_____
> Exercise your brain! Try Flexicon. 
> http://games.msn.com/en/flexicon
/default.htm?icid=flexicon_hmemailtaglineapril07 
> 
> 
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 
> 
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

At the risk of slowing down performance even further, I
would suggest  
that you increase the logging in the postgres database to
indicate  
timing/cache information for each SQL run.
This will help you determine which, if any, SQL statements
are taking  
up all the time and at least help separate potential
performance  
issues between pgsql and dbmail.
However, I have not heard any results on simply running top
to see  
who is taking up the CPU load in real time....  Maybe I'm an
email or  
two behind on the thread.

Do you know if the highest user is indeed dbmail or
postgres?

On Apr 5, 2007, at 12:57 AM, Eric Hiller wrote:

> I ran dbmail-util -cy and it helped some, but not much.
 I clocked  
> the loading a single message about 2 paragraphs in
length, no  
> attachments, at around 5 seconds both before and after
dbmail-util - 
> cy.
>
> Everything here is local, so it isnt connection speed
slowing it  
> down to my knowledge.
>
>
>> From: "Aaron Stone" <aaronserendipity.cx>
>> Reply-To: DBMail mailinglist <dbmaildbmail.org>
>> To: <jessekci.net>, "DBMail
mailinglist" <dbmaildbmail.org>
>> Subject: Re: [Dbmail] 2.2.2 slow
>> Date: Wed, 4 Apr 2007 21:35:58 -0000
>>
>> SVN should be stable at this time, though we have a
few bugs  
>> outstanding
>> that have not been completely identified and
resolved. Your  
>> mileage may
>> vary.
>>
>> But that's sort of beside the point -- pegging the
cpu at 100% for 2
>> seconds upon each message delivery is not a
"performance issue,"  
>> it's a
>> disaster! Something on Eric's machine is not right,
and hopefully  
>> we'll be
>> able to help identify and resolve the issue with
him.
>>
>> Aaron
>>
>> On Wed, Apr 4, 2007, Jesse Norell <jessekci.net> said:
>>
>> > There have been some changes to improve speed
since 2.2.2 though,
>> > haven't there?  From irc conversation, another
pertinent  
>> question is, is
>> > 2.2 svn stable right now?  I know there were a
run of issues a  
>> week or
>> > two back, but have the major issues cleared? 
If so, Eric could  
>> probably
>> > try latest svn and report back on speed
differences.
>> >
>> > Jesse
>> >
>> >
>> > On Wed, 2007-04-04 at 20:33 +0000, Aaron Stone
wrote:
>> >> That's not DBMail being slow, it's your
database. Run top  
>> during message
>> >> delivery and you'll see who's eating the
cpu. Most likely you  
>> need to
>> >> vacuum/optimize/analyze your tables.
dbmail-util -c will do  
>> this for you.
>> >>
>> >> Aaron
>> >>
>> >> On Wed, Apr 4, 2007, Eric Hiller
<mrraptor98hotmail.com> said:
>> >>
>> >> > I have been running 2.2.2 and it has
been very stable.  Ran  
>> it as soon as it
>> >> > came out and it worked on a test
machine.  Only thing is it  
>> is MUCH slower
>> >> > than 2.0.10. Any mail request and the
sql server cpu is  
>> pegged at 100% for
>> >> > 2+ seconds.  Is this issue resolved,
or will it be in 2.2.5?
>> >> >
>> >> > Thanks much for dbmail it really has
been great,
>> >> > Eric
>> >
>> > --
>> > Jesse Norell - jessekci.net
>> > Kentec Communications, Inc.
>> >
>> >
_______________________________________________
>> > DBmail mailing list
>> > DBmaildbmail.org
>> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>> >
>>
>> --
>>
>>
>>
>> _______________________________________________
>> DBmail mailing list
>> DBmaildbmail.org
>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>
____________________________________________________________
_____
> Exercise your brain! Try Flexicon. http://games.msn.co
m/en/flexicon/ 
> default.htm?icid=flexicon_hmemailtaglineapril07
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail