From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
---|---|
To: | The Hermit Hacker <scrappy(at)hub(dot)org>, Mitch Vincent <mitch(at)huntsvilleal(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Why Not MySQL? |
Date: | 2000-05-03 16:38:41 |
Message-ID: | 3.0.1.32.20000503093841.00f0fd50@mail.pacifier.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
At 11:44 AM 5/3/00 -0300, The Hermit Hacker wrote:
>My experience so far is that it was basically a 'plug-n-play' sort of
>thing ... dump your database, upgrade and reload ... the only problem I
>had was one script that I did something like:
>
>SELECT field as field
I was able to dump my birdnotes.net database and reload it without change,
if another datapoint will help your boss's confidence level.
>without realizing it, and v7.0 won't allow that (field == field) ... other
>then that, *much* more stable, and appears faster then the old ...
My system had one query in particular that suffered from a poor
plan (a very bad nested loop), the changes to the optimizer have
resulted in a much better plan in 7.0 which just flies. I've been
very happy with 7.0.
Tell your boss we're smarter than he is and switch :)
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-05-03 17:08:42 | Re: 7.0RC2 compile error ! |
Previous Message | The Hermit Hacker | 2000-05-03 16:32:17 | Re: 7.0RC2 compile error ! |