It should just work. The DB Server would need to have all it's libs updated. Any psql client use of the Backslash (\) commands wouldn't work, but basic query stuff is backwards compatible.
You should plan to upgrade, but it doesn't have to be a big-bang. 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: Friday, April 06, 2007 10:46 AM To: [email protected] Subject: Re: [Dbmail] 2.2.2 slow 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 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
