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
