Linux/Alpha and Postgres 7.0 Beta Status

Started by Ryan Kirkpatrickalmost 26 years ago4 messages
#1Ryan Kirkpatrick
pgsql@rkirkpat.net

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/ |
---------------------------------------------------------------------------

#2The Hermit Hacker
scrappy@hub.org
In reply to: Ryan Kirkpatrick (#1)
Re: [HACKERS] Linux/Alpha and Postgres 7.0 Beta Status

*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

#3Ryan Kirkpatrick
pgsql@rkirkpat.net
In reply to: The Hermit Hacker (#2)
Re: [HACKERS] Linux/Alpha and Postgres 7.0 Beta Status

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/ |
---------------------------------------------------------------------------

#4Ryan Kirkpatrick
pgsql@rkirkpat.net
In reply to: Ryan Kirkpatrick (#1)
Re: [HACKERS] Linux/Alpha and Postgres 7.0 Beta Status

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/ |
---------------------------------------------------------------------------