From: "Larry Rosenman" <[email protected]>
Reply-To: DBMail mailinglist <[email protected]>
To: "'DBMail mailinglist'" <[email protected]>
Subject: RE: [Dbmail] 2.2.2 slow
Date: Thu, 5 Apr 2007 09:38:30 -0500
you could use the PostgreSQL Global Development Group released RPM's. The
RHEL4 ones are fine on CentOS 4.4 (I run it here).
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: [email protected]
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Of Eric Hiller
Sent: Thursday, April 05, 2007 9:20 AM
To: [email protected]
Subject: RE: [Dbmail] 2.2.2 slow
I am running centos as my OS for pgsql(dbmail is debian), and wanted to
stay
as packaged-based as I could on my machines. I'll probably run pgsql 8.1
when centos5 is released.
I'll run the vacuumdb command this evening, I have done that before, It
usually does about the same as dbmail-util -cy, in that there is a slight
improvement but not much.
Does anyone else have these issues with similar speed? or is it something
specific to me, and I should be looking elsewhere for the issue?
Thanks,
Eric
>From: "Larry Rosenman" <[email protected]>
>Reply-To: DBMail mailinglist <[email protected]>
>To: "'DBMail mailinglist'" <[email protected]>
>Subject: RE: [Dbmail] 2.2.2 slow
>Date: Thu, 5 Apr 2007 08:29:04 -0500
>
>I would recommend 8.1 or 8.2 very much. there are LOTS of performance
>enhancements in both of those releases.
>
>LER
>
>
>--
>Larry Rosenman http://www.lerctr.org/~ler
>Phone: +1 512-248-2683 E-Mail: [email protected]
>US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf
>Of Eric Hiller
>Sent: Wednesday, April 04, 2007 9:10 PM
>To: [email protected]
>Subject: Re: [Dbmail] 2.2.2 slow
>
>It is postgresql server, but not pg8, it is 7.4.8, so no autovacuum (as
far
>as I know).
>
>If I upgraded to svn would I need to do anything besides just recompiling
>the source? (just make and install)
>
>- Eric
>
>
> >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
>
>_________________________________________________________________
>The average US Credit Score is 675. The cost to see yours: $0 by
Experian.
>http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTERAV
E
>RAGE
>
>_______________________________________________
>DBmail mailing list
>[email protected]
>https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>_______________________________________________
>DBmail mailing list
>[email protected]
>https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________________________________________________
Mortgage refinance is Hot. *Terms. Get a 5.375%* fix rate. Check savings
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search
=mortgage_text_links_88_h2bbb&disc=y&vers=925&s=4056&p=5117
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
