Thread: Postgresql mentioned on Newsforge MySQL article

Postgresql mentioned on Newsforge MySQL article

From
Tony Caduto
Date:
http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml

Don't know the validity of this dvd order test they did, but the article
claims Postgresql only did 120 OPM.
Seems a little fishy to me.

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration


Re: Postgresql mentioned on Newsforge MySQL article

From
"Joshua D. Drake"
Date:
Tony Caduto wrote:
> http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml
>
> Don't know the validity of this dvd order test they did, but the article
> claims Postgresql only did 120 OPM.
> Seems a little fishy to me.
>

This has got to be a complete joke.

Joshua D. Drake

--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



Re: Postgresql mentioned on Newsforge MySQL article

From
Peter Eisentraut
Date:
Tony Caduto wrote:
> http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml
>
> Don't know the validity of this dvd order test they did, but the
> article claims Postgresql only did 120 OPM.

The contest evaluated the solutions sent in by whoever wanted to
participate.  This doesn't prove anything, except that the MySQL
marketing department is exceptionally slow.  These contest results were
published months ago.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: Postgresql mentioned on Newsforge MySQL article

From
Chris Mair
Date:
> http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml
>
> Don't know the validity of this dvd order test they did, but the article
> claims Postgresql only did 120 OPM.
> Seems a little fishy to me.

There was just one submission for PostgreSQL made by one guy who didn't
manage to finish it (c't says connection pooling didn't work).

See: http://archives.postgresql.org/pgsql-advocacy/2006-06/msg00052.php

MySQL's winning submission was by a team from MySQL AB.

Enough said...

Bye,
Chris.

PS: this is, by the way a few months old, I'm wondering why MySQL
does the press release only now...


--

Chris Mair
http://www.1006.org



Re: Postgresql mentioned on Newsforge MySQL article

From
Bill Moran
Date:
In response to Chris Mair <chrisnospam@1006.org>:

>
> > http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml
> >
> > Don't know the validity of this dvd order test they did, but the article
> > claims Postgresql only did 120 OPM.
> > Seems a little fishy to me.
>
> There was just one submission for PostgreSQL made by one guy who didn't
> manage to finish it (c't says connection pooling didn't work).
>
> See: http://archives.postgresql.org/pgsql-advocacy/2006-06/msg00052.php
>
> MySQL's winning submission was by a team from MySQL AB.

It's just kind of a shame that we didn't have a chance to put together
a serious entry ...

This is the first I've heard of the contest.

--
Bill Moran
Collaborative Fusion Inc.

Re: Postgresql mentioned on Newsforge MySQL article

From
"Brandon Aiken"
Date:
Looks like it was a design contest not a benchmark to me.  Surprise,
surprise, the team that personally designs a DBMS has the best
performing DBMS.  The second place winner, Alexander Burger, is the
author of the solution he used: Pico LISP.  The third place team,
MonetDB, used their solution, MonetDB.

The results tell me that people who write databases can write good apps
that use those same databases.  And the world collectively says "O
RLY?".

--
Brandon Aiken
CS/IT Systems Engineer

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tony Caduto
Sent: Monday, August 28, 2006 4:33 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgresql mentioned on Newsforge MySQL article

http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml

Don't know the validity of this dvd order test they did, but the article

claims Postgresql only did 120 OPM.
Seems a little fishy to me.

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Postgresql mentioned on Newsforge MySQL article

From
Ned Lilly
Date:

Chris Mair wrote:
>
> PS: this is, by the way a few months old, I'm wondering why MySQL
> does the press release only now...

Because they don't have anything else to talk about, and are filling a vacuum?

Cheers,
NL

Re: Postgresql mentioned on Newsforge MySQL article

From
Scott Marlowe
Date:
On Mon, 2006-08-28 at 16:02, Joshua D. Drake wrote:
> Tony Caduto wrote:
> > http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml
> >
> > Don't know the validity of this dvd order test they did, but the article
> > claims Postgresql only did 120 OPM.
> > Seems a little fishy to me.
> >
>
> This has got to be a complete joke.

I'm wondering if the source code is available.

My guess is it was full of MySQLisms and the postgresql "port" was
written without indexes, no transactions, and relied on running dozens
of queries that postgresql could have more efficiently done in one query
or in one transaction at least.

I wonder if one couldn't get ahold of the code and "fix it" to see what
postgresql could actually do.

We have the same problem at work.  RT is a great little program that
supports several database backends.  But it's dumbed down to make MySQL
3.23 happy and fast, so it's kinda a dog on PostgreSQL, even though it's
ultra stable.  Seems the newest release is finally catching up on
PostgreSQL.

Re: Postgresql mentioned on Newsforge MySQL article

From
Markus Schiltknecht
Date:
Tony Caduto wrote:
> http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml
>
> Don't know the validity of this dvd order test they did, but the article
> claims Postgresql only did 120 OPM.
> Seems a little fishy to me.

Now, this article really s**ks! First of all, the original contest was
specifically not only about performance. And the MySQL team did a whole
lot of dirty tricks (i.e. using memcached) to push their solution.

I am the one who has written he only PostgreSQL entry, for which I'm
still sorry and ashamed, because it performs so poorly. I just didn't
have much spare time to spend, but thought I'd send it in anyway. One of
the reasons it did not perform well was, that I simply have forgotten to
enable connection pooling.

Another entry using Perl and PostgreSQL from somebody who put a lot more
time and effort into it was disqualified because the benchmarker claimed
the files came in to late. While the author of the PostgreSQL solution
claims the wrong ZIP archive has been used.

Besides, was quite a simple database test, not too complicated queries,
very few stored procedures. No views, no triggers, no 2PC, no nothing.
So IMHO it was not even a good test of database extensibility.

So this comparison is really just... ah! forget about it! (Just please,
next time, let's put a little more effort into such a thing.)

Regards

Markus

Re: Postgresql mentioned on Newsforge MySQL article

From
Peter Eisentraut
Date:
Scott Marlowe wrote:
> I'm wondering if the source code is available.

http://www.heise.de/ct/dbcontest/teilnehmer.shtml

> My guess is it was full of MySQLisms and the postgresql "port" was
> written without indexes, no transactions, and relied on running
> dozens of queries that postgresql could have more efficiently done in
> one query or in one transaction at least.

Your guess is wrong.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: Postgresql mentioned on Newsforge MySQL article

From
Scott Marlowe
Date:
On Mon, 2006-08-28 at 17:06, Markus Schiltknecht wrote:
> Tony Caduto wrote:
> > http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml
> >
> > Don't know the validity of this dvd order test they did, but the article
> > claims Postgresql only did 120 OPM.
> > Seems a little fishy to me.
>
> Now, this article really s**ks! First of all, the original contest was
> specifically not only about performance. And the MySQL team did a whole
> lot of dirty tricks (i.e. using memcached) to push their solution.
>
> I am the one who has written he only PostgreSQL entry, for which I'm
> still sorry and ashamed, because it performs so poorly. I just didn't
> have much spare time to spend, but thought I'd send it in anyway. One of
> the reasons it did not perform well was, that I simply have forgotten to
> enable connection pooling.

Was this all the same basic task implemented by different teams then?

Can we see the code?  hack it?  I'm sure someone here could help out.

I don't care about the contest, but it would be nice to be able to put
out a version that could compete with MySQL's.

Re: Postgresql mentioned on Newsforge MySQL article

From
Scott Marlowe
Date:
On Mon, 2006-08-28 at 17:34, Peter Eisentraut wrote:
> Scott Marlowe wrote:
> > I'm wondering if the source code is available.
>
> http://www.heise.de/ct/dbcontest/teilnehmer.shtml
>
> > My guess is it was full of MySQLisms and the postgresql "port" was
> > written without indexes, no transactions, and relied on running
> > dozens of queries that postgresql could have more efficiently done in
> > one query or in one transaction at least.
>
> Your guess is wrong.

Yes, I see that now.  I thought it was one version of the same app
pointed at different DBs.

I see now that it's not.  See my most recent post...

Re: Postgresql mentioned on Newsforge MySQL article

From
Markus Schiltknecht
Date:
Scott Marlowe wrote:
> Was this all the same basic task implemented by different teams then?

Yep.

> Can we see the code?  hack it?  I'm sure someone here could help out.

Sure.

> I don't care about the contest, but it would be nice to be able to put
> out a version that could compete with MySQL's.

Sure. The main db-contest site of the magazine is [1], but it's all
german. You'lll find an english translation of the original article,
describing the problem to solve in [2].

The contest entries are downloadable on [3]. Mine is the 'bluegap' one.
If you want to hack together a high-performance solution based on
PostgreSQL I'd start with Alvar C.H. Freude's disqualified entry.

Happy hacking

Markus


[1]: http://www.heise.de/ct/dbcontest/
[2]: http://firebird.sourceforge.net/connect/ct-dbContest.html
[3]: http://www.heise.de/ct/dbcontest/teilnehmer.shtml

Re: Postgresql mentioned on Newsforge MySQL article

From
Robert Treat
Date:
On Monday 28 August 2006 17:04, Peter Eisentraut wrote:
> Tony Caduto wrote:
> > http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml
> >
> > Don't know the validity of this dvd order test they did, but the
> > article claims Postgresql only did 120 OPM.
>
> The contest evaluated the solutions sent in by whoever wanted to
> participate.  This doesn't prove anything, except that the MySQL
> marketing department is exceptionally slow.  These contest results were
> published months ago.

Seems they are fast where it counts... namely getting a team of developers on
top of the contest so they come out shining.  Too bad people in this
community don't see the value of paying people to do advocacy related
development.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: Postgresql mentioned on Newsforge MySQL article

From
Martijn van Oosterhout
Date:
On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote:
> Seems they are fast where it counts... namely getting a team of developers on
> top of the contest so they come out shining.  Too bad people in this
> community don't see the value of paying people to do advocacy related
> development.

I don't remember this ever being mentioned on the lists? I never heard
of it. Maybe if it had been mentioned here it would've got more
attention?

It's true there isn't a group here looking for competitions to enter...

Have a ncie day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

Re: Postgresql mentioned on Newsforge MySQL article

From
AgentM
Date:
On Aug 30, 2006, at 16:11 , Martijn van Oosterhout wrote:

> On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote:
>> Seems they are fast where it counts... namely getting a team of
>> developers on
>> top of the contest so they come out shining.  Too bad people in this
>> community don't see the value of paying people to do advocacy related
>> development.
>
> I don't remember this ever being mentioned on the lists? I never heard
> of it. Maybe if it had been mentioned here it would've got more
> attention?
>
> It's true there isn't a group here looking for competitions to
> enter...

Perhaps because PostgreSQL is too busy competing with itself? Is
anyone aware of any other open-source project that has added so many
new features in the past year?

-M

Re: Postgresql mentioned on Newsforge MySQL article

From
"Joshua D. Drake"
Date:
Martijn van Oosterhout wrote:
> On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote:
>> Seems they are fast where it counts... namely getting a team of developers on
>> top of the contest so they come out shining.  Too bad people in this
>> community don't see the value of paying people to do advocacy related
>> development.
>
> I don't remember this ever being mentioned on the lists? I never heard
> of it. Maybe if it had been mentioned here it would've got more
> attention?
>
> It's true there isn't a group here looking for competitions to enter...
>
> Have a ncie day,

I *think* Robert's point is that a paid advocate may have actually been
looking for this type of thing to come up and would help organize an effort.

Sincerely,

Joshua D. Drake

--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



Re: Postgresql mentioned on Newsforge MySQL article

From
Robert Treat
Date:
On Wednesday 30 August 2006 16:48, Joshua D. Drake wrote:
> Martijn van Oosterhout wrote:
> > On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote:
> >> Seems they are fast where it counts... namely getting a team of
> >> developers on top of the contest so they come out shining.  Too bad
> >> people in this community don't see the value of paying people to do
> >> advocacy related development.
> >
> > I don't remember this ever being mentioned on the lists? I never heard
> > of it. Maybe if it had been mentioned here it would've got more
> > attention?
> >

FWIW it was mentioned and discussed on the german postgresql list.

> > It's true there isn't a group here looking for competitions to enter...
> >
> I *think* Robert's point is that a paid advocate may have actually been
> looking for this type of thing to come up and would help organize an
> effort.
>

Right... these types of things come up all the time, whether they be
benchmarks, contests, tutorials, or just general application support, and all
of the commercial database companies (ie. oracle, ibm, ms, mysql) have people
on staff to point at these tasks.  The community has been good about full
time developers working on core, but seems to overlook all of the other areas
that you can point a paid developer that will increase adoption.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: Postgresql mentioned on Newsforge MySQL article

From
Tim Allen
Date:
Martijn van Oosterhout wrote:
> On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote:
>
>>Seems they are fast where it counts... namely getting a team of developers on
>>top of the contest so they come out shining.  Too bad people in this
>>community don't see the value of paying people to do advocacy related
>>development.
>
>
> I don't remember this ever being mentioned on the lists? I never heard
> of it. Maybe if it had been mentioned here it would've got more
> attention?
>
> It's true there isn't a group here looking for competitions to enter...
>
> Have a ncie day,

Speaking for myself, I'm _delighted_ that the core postgres developers
spend their time improving postgres, rather than spending their time on
random beauty contests.

Tim

--
-----------------------------------------------
Tim Allen          tim@proximity.com.au
Proximity Pty Ltd  http://www.proximity.com.au/