By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,198 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

TPC-C and Postgres

P: n/a
I found this article:

http://www.serverwatch.com/news/arti...24_1126981_Ext

that is clear out dated, it's anyway a good comparison with
mysql.

Do you know if someone did the TPC-C test with
7.4.X version ?

Googling with: TPC-C Postgres

I also found this:
http://www.linux-magazine.com/issue/08/023-PostSQL.pdf
Regards
Gaetano Mendola
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Quoting Gaetano Mendola <me*****@bigfoot.com>:
I found this article:

http://www.serverwatch.com/news/arti...24_1126981_Ext

that is clear out dated, it's anyway a good comparison with
mysql.

Do you know if someone did the TPC-C test with
7.4.X version ?

Googling with: TPC-C Postgres

I also found this:
http://www.linux-magazine.com/issue/08/023-PostSQL.pdf
On page 7 of this document:

"Earlier versions of Postgres were often unstable and quite often there were
even data losses. The Postgres developer team has invested a great deal of time
in regression tests, which guarantee high stability and data security. Releases
now only occur after longer Beta phases. The new versions of Postgres have
become considerably more effective (see box Benchmarks ).

There are not known to be any serious stability problems with MySQL. With the
new feature of replicability, the system has taken another major step in the
direction of increased failure safety. Especially in conjunction with PHP, MySQL
achieves good performance values in web applications (see box Benchmarks ). A
paper by the founder of MySQL, Michael Widenius on performance optimisation is
recommended in this respect"
Hmmmm...

Regards
Gaetano Mendola

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #2

P: n/a


On page 7 of this document:

"Earlier versions of Postgres were often unstable and quite often there were
even data losses. The Postgres developer team has invested a great deal of time
in regression tests, which guarantee high stability and data security. Releases
now only occur after longer Beta phases. The new versions of Postgres have
become considerably more effective (see box Benchmarks ).

There are not known to be any serious stability problems with MySQL. With the
new feature of replicability, the system has taken another major step in the
direction of increased failure safety. Especially in conjunction with PHP, MySQL
achieves good performance values in web applications (see box Benchmarks ). A
paper by the founder of MySQL, Michael Widenius on performance optimisation is
recommended in this respect"
Hmmmm...


Sounds like he has Mysql And Pg confused... :-)

e.g :

Recently a colleage of mine, who is fond of Mysql initiated a friendly
challenge to the effect "Mysql can do big queries just as well as Pg".

I suggested he try my Data Warehouse benchmark
(http://sourceforge.net/projects/benchw)
with size 10 (about 10G or so).

I went away, produced my results (using Pg 7.4) and mailed them to
him... however at his end - he cannot get Mysql to load the data (it
kills his connection,.. thats nice). He is not impressed at all, and is
considering using Pg!

(he was using Mysql 4.0.15)

regards

Mark

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

Nov 12 '05 #3

P: n/a
Quoting Mark Kirkwood <ma****@paradise.net.nz>:


On page 7 of this document:

"Earlier versions of Postgres were often unstable and quite often there were
even data losses. The Postgres developer team has invested a great deal of

time
in regression tests, which guarantee high stability and data security.

Releases
now only occur after longer Beta phases. The new versions of Postgres have
become considerably more effective (see box Benchmarks ).

There are not known to be any serious stability problems with MySQL. With

the
new feature of replicability, the system has taken another major step in

the
direction of increased failure safety. Especially in conjunction with PHP,

MySQL
achieves good performance values in web applications (see box Benchmarks ).

A
paper by the founder of MySQL, Michael Widenius on performance optimisation

is
recommended in this respect"
Hmmmm...


Sounds like he has Mysql And Pg confused... :-)


Yea, thats what I thought- 2001 was not that long ago...
e.g :

Recently a colleage of mine, who is fond of Mysql initiated a friendly
challenge to the effect "Mysql can do big queries just as well as Pg".

I suggested he try my Data Warehouse benchmark
(http://sourceforge.net/projects/benchw)
with size 10 (about 10G or so).
Nice real nice. I need to probably get that and run some test against MSSQL.
I'm working on developing my own test dataset for some environments tests in the
social services world but your software would be useful for some "raw" tests.
I went away, produced my results (using Pg 7.4) and mailed them to
him... however at his end - he cannot get Mysql to load the data (it
kills his connection,.. thats nice). He is not impressed at all, and is
considering using Pg!

(he was using Mysql 4.0.15)
Once again proof is in the pudding!
regards

Mark

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

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.