When running top, the postmaster process is what takes up all the cpu.
I ran the vacuumdb last night, and that decreased the load time of a message
from 5+ seconds to 2+ seconds, still pretty long though.
Larry, do you know if I would have to update all my pgsql libs on all my
machines that access that pgsql server if I upgraded to 8.2? (ie. php,
asterisk, etc.) Or would it just work?
Thanks,
Eric
From: tom <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: DBMail mailinglist <[email protected]>
Subject: Re: [Dbmail] 2.2.2 slow
Date: Fri, 6 Apr 2007 09:09:55 -0400
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" <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: <[EMAIL PROTECTED]>, "DBMail mailinglist" <[email protected]>
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 - [EMAIL PROTECTED]
> Kentec Communications, Inc.
>
> _______________________________________________
> DBmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
_______________________________________________
DBmail mailing list
[email protected]
https://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
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________________________________________________
Need a break? Find your escape route with Live Search Maps.
http://maps.live.com/?icid=hmtag3
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
