List:General Discussion« Previous MessageNext Message »
From:The Hermit Hacker Date:October 3 1999 10:02pm
Subject:Re: [PHP3] Re: PostgreSQL vs Mysql comparison
View as plain text  
On Sat, 2 Oct 1999, Patrick Greenwell wrote:

> On Sat, 2 Oct 1999, Scott Perkins wrote:
> 
> > You make a good point about available admin and other facilities etc.
> > 
> > I am interested in some of the forum functionalities that seem to be "off the
> > shelf" with Mysql but I have not done my homework yet with PostgreSQL.  There
> > must me some good reasons why PostgreSQL beat out
> > Mysql for product of the year  or best database or most popular among 
> > NIX/NUX users or something recently.  
> 
> Because the Postgres mailing list was informed of the vote and apparently
> had more members that voted than the MySQL list did. To put awards based on web
> polls in perspective, "Hank, the angry drunken dwarf" won the "most
> beautiful person in show business" award on People Magazines website
> earlier this year. In other words, I wouldn't take the voting or the award
> for most popular database very seriously given the voting methodology...

Wait...we'er talking about two different things here...if you are
referring to the "LinuxWorld Editors Choice Award" that we recently
won...that had nothing (or, at least as far as any of us knew) to do with
any WWW based poll that we are aware of...

The only WWW based poll that we are aware of was put on by LinuxDev.Net,
viewable at:

	http://linuxdev.net/cgi-bin/pollit/poll_it.cgi?load=lastpoll

Or, does LinuxWorld own LinuxDev.Net?

> Postgres is certainly significantly slower than MySQL according to the
> MySQL benchmarks

	Is that the benchmarks that are still based on v6.4.2? *raised
eyebrow*  We saw a significant performance increase when we moved from the
old 'table locking' to MVCC ...

	Also, please note also that those benchmarks were/are based on
what MySQL is capable of, not what the other SQL servers are capable of.  
For instance, if I take an SQL query that has been "optimized for MySQL"
and run it verbatim under PostgreSQL, the difference is a 2sec result for
MySQL vs 19sec for PostgreSQL ... if I re-write that query for
PostgreSQL's featuers (namely, using subselects), i can get the query down
to 1sec *shrug*

	Would be interesting to see us (PostgreSQL) come up with
benchmarks against MySQL...we'd be able to put stuff like "couldn't
test under MySQL, since they don't support this SQL construct"...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@stripped           secondary: scrappy@{freebsd|postgresql}.org 

Thread
PostgreSQL vs Mysql comparisonScott Perkins2 Oct
  • Re: PostgreSQL vs Mysql comparisonPatrick Greenwell2 Oct
    • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
      • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonPaul DuBois4 Oct
        • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
          • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonrandyboy4 Oct
            • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
              • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                • Re: PostgreSQL vs Mysql comparisonMartin Ramsch4 Oct
                  • Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
                    • Re: PostgreSQL vs Mysql comparisonTonu Samuel4 Oct
                    • Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
                  • Re: PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                    • Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
                      • Re: PostgreSQL vs Mysql comparisonBruce Momjian6 Oct
                        • Re: PostgreSQL vs Mysql comparisonMichael Widenius7 Oct
                          • Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker7 Oct
                            • Re: PostgreSQL vs Mysql comparisonBruce Momjian7 Oct
                              • Re: PostgreSQL vs Mysql comparisonMichael Widenius7 Oct
                                • Re: PostgreSQL vs Mysql comparisonMatthias Urlichs7 Oct
                        • Re: [GENERAL] Re: PostgreSQL vs Mysql comparisonAaron J. Seigo7 Oct
                      • Re: PostgreSQL vs MySQL benchmark...Dimitri24 Jul
                  • Re: PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                    • Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
                      • Re: PostgreSQL vs Mysql comparisonBruce Momjian6 Oct
                • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonPaul DuBois4 Oct
                  • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                    • Re: [PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonDuncan Kinder4 Oct
                      • Re: [PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker4 Oct
                        • Re: [PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonDuncan Kinder4 Oct
                    • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
              • PostgreSQL vs Mysql comparisonScott Perkins4 Oct
                • Re: [GENERAL] PostgreSQL vs Mysql comparisonBruce Momjian4 Oct
                • Re: PostgreSQL vs Mysql comparisonLuuk de Boer4 Oct
                • PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
              • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonLuuk de Boer4 Oct
          • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonAaron J. Seigo4 Oct
            • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
              • Re: [PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonRasmus Lerdorf6 Oct
              • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonAaron J. Seigo7 Oct
          • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonLuuk de Boer4 Oct
          • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
            • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonThe Hermit Hacker7 Oct
              • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius7 Oct
          • Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparisonTom Dryden7 Oct
        • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonPatrick Greenwell4 Oct
      • Re: [PHP3] Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
    • Re: PostgreSQL vs Mysql comparisonMichael Widenius6 Oct
  • Re: PostgreSQL vs Mysql comparisonJames Manning2 Oct
Re: PostgreSQL vs Mysql comparisonBruce Momjian7 Oct