Thread

  1. Linux/Alpha and Postgres 7.0 Beta Status

    Ryan Kirkpatrick <pgsql@rkirkpat.net> — 2000-04-05T00:32:48Z

    	I finally managed to catch up with the 7.0 betas (provided beta5
    does not come out in the next few hours :). My web site has been updated
    with the Linux/Alpha patches for 7.0beta4 (see the software section), and
    for history's sake, I have also listed the Linux/Alpha patches for all
    version of PostgreSQL that the patches have existed for.
    	With these patches applied to the 7.0beta4 tarball, all regression
    tests pass (save for geometry with the harmless off by one in the nth
    decimal place error). I have also tested it against a few of my own apps
    and while there were a few quirks in conversion (i.e. int() -> int4()),
    nothing major was encountered. I would encourage anyone running pgsql on
    Linux/Alpha to pound on these patches and make sure it works for them as
    soon as possible. Email me any Linux/Alpha specific problems found.
    	I also have to say that 7.0 is much faster than 6.5.3. It used to
    take 10 to 15 minutes to load 125k rows into pgsql, now it takes only 5
    minutes for the same data on the same machine! Good work!
    	When the final version of 7.0 comes out, I will double check the
    patch still work (and make modifications as necessary), update my web
    page, and post a short message here. Beyond that, I have very little time
    to work on pgsql until mid May as I have a few projects that need to be
    finished ASAP before I can graduate. :) Once I have graduated, I plan to
    put some time in on getting the Linux/Alpha patches cleaned up and
    intergrated into the main source tree, hopefully in time for 7.1. 
    	I will post the 7.0beta4 Linux/Alpha patch to the patches list
    shortly. That is all. TTYL.
    
    	PS. Maybe a note should be put on the pgsql ports page that
    patches are needed for Linux/Alpha an a ref to my web page.
    
    ---------------------------------------------------------------------------
    |   "For to me to live is Christ, and to die is gain."                    |
    |                                            --- Philippians 1:21 (KJV)   |
    ---------------------------------------------------------------------------
    |   Ryan Kirkpatrick  |  Boulder, Colorado  |  http://www.rkirkpat.net/   |
    ---------------------------------------------------------------------------
    
    
    
  2. Re: [HACKERS] Linux/Alpha and Postgres 7.0 Beta Status

    Marc G. Fournier <scrappy@hub.org> — 2000-04-05T00:54:30Z

    *rofl* I haven't even had a chance to write up the ChangeLog/announcement
    for beta4 yet :)  I just made the tarball itself a few hours ago so that
    it had a chance to propogate through the mirror sites ...
    
     On Tue, 4 Apr 2000, Ryan Kirkpatrick wrote:
    
    > 
    > 	I finally managed to catch up with the 7.0 betas (provided beta5
    > does not come out in the next few hours :). My web site has been updated
    > with the Linux/Alpha patches for 7.0beta4 (see the software section), and
    > for history's sake, I have also listed the Linux/Alpha patches for all
    > version of PostgreSQL that the patches have existed for.
    > 	With these patches applied to the 7.0beta4 tarball, all regression
    > tests pass (save for geometry with the harmless off by one in the nth
    > decimal place error). I have also tested it against a few of my own apps
    > and while there were a few quirks in conversion (i.e. int() -> int4()),
    > nothing major was encountered. I would encourage anyone running pgsql on
    > Linux/Alpha to pound on these patches and make sure it works for them as
    > soon as possible. Email me any Linux/Alpha specific problems found.
    > 	I also have to say that 7.0 is much faster than 6.5.3. It used to
    > take 10 to 15 minutes to load 125k rows into pgsql, now it takes only 5
    > minutes for the same data on the same machine! Good work!
    > 	When the final version of 7.0 comes out, I will double check the
    > patch still work (and make modifications as necessary), update my web
    > page, and post a short message here. Beyond that, I have very little time
    > to work on pgsql until mid May as I have a few projects that need to be
    > finished ASAP before I can graduate. :) Once I have graduated, I plan to
    > put some time in on getting the Linux/Alpha patches cleaned up and
    > intergrated into the main source tree, hopefully in time for 7.1. 
    > 	I will post the 7.0beta4 Linux/Alpha patch to the patches list
    > shortly. That is all. TTYL.
    > 
    > 	PS. Maybe a note should be put on the pgsql ports page that
    > patches are needed for Linux/Alpha an a ref to my web page.
    > 
    > ---------------------------------------------------------------------------
    > |   "For to me to live is Christ, and to die is gain."                    |
    > |                                            --- Philippians 1:21 (KJV)   |
    > ---------------------------------------------------------------------------
    > |   Ryan Kirkpatrick  |  Boulder, Colorado  |  http://www.rkirkpat.net/   |
    > ---------------------------------------------------------------------------
    > 
    
    Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
    Systems Administrator @ hub.org 
    primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 
    
    
    
  3. Re: [HACKERS] Linux/Alpha and Postgres 7.0 Beta Status

    Ryan Kirkpatrick <pgsql@rkirkpat.net> — 2000-04-05T03:20:46Z

    On Tue, 4 Apr 2000, The Hermit Hacker wrote:
    
    > *rofl* I haven't even had a chance to write up the ChangeLog/announcement
    > for beta4 yet :)  I just made the tarball itself a few hours ago so that
    > it had a chance to propogate through the mirror sites ...
    > 
    >  On Tue, 4 Apr 2000, Ryan Kirkpatrick wrote:
    > > 	I finally managed to catch up with the 7.0 betas (provided beta5
    > > does not come out in the next few hours :). My web site has been updated
    > > with the Linux/Alpha patches for 7.0beta4 (see the software section), and
    > > for history's sake, I have also listed the Linux/Alpha patches for all
    > > version of PostgreSQL that the patches have existed for.
    
    	I was wondering why there had been no annoucement on the lists
    yet about it, though I did notice it was date stamped today. Didn't
    realize I had caught it quite that quick though. :)
    	I was just cleaning up the patches and web page for beta3 when I
    thought I had better check the ftp site just one more time. Especially
    after the last two times I have sat down to work on the Linux/Alpha
    patches, before I could finish a new beta would come out... and I it was
    true once again! :( Thankfully, my current beta3 patch applied only with a
    tad bit of fuzz to beta4. It was only the beta1 to beta2 transistion that
    was painful (thanks to int8.c). I guess it is only fair that I got "ahead"
    for once.
    	Glad I was able to add a bit of humor to your day. :)
    
    ---------------------------------------------------------------------------
    |   "For to me to live is Christ, and to die is gain."                    |
    |                                            --- Philippians 1:21 (KJV)   |
    ---------------------------------------------------------------------------
    |   Ryan Kirkpatrick  |  Boulder, Colorado  |  http://www.rkirkpat.net/   |
    ---------------------------------------------------------------------------
    
    
    
  4. Re: [HACKERS] Linux/Alpha and Postgres 7.0 Beta Status

    Ryan Kirkpatrick <pgsql@rkirkpat.net> — 2000-04-17T02:48:46Z

    	Just to let everyone know, I have updated the Linux/Alpha patches
    to work with the newest beta, 7.0beta5. Nothing new to report, beta5
    appears to be working fine on my Alpha box after regression tests and a
    test of a few of my own apps. The patches are on my web site as usual.
    That is all. TTYL.
    
    ---------------------------------------------------------------------------
    |   "For to me to live is Christ, and to die is gain."                    |
    |                                            --- Philippians 1:21 (KJV)   |
    ---------------------------------------------------------------------------
    |   Ryan Kirkpatrick  |  Boulder, Colorado  |  http://www.rkirkpat.net/   |
    ---------------------------------------------------------------------------