More MySQL vs. Postgres

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #295,167 by admin 10/26/07 3:00:37 PM Reply	More MySQL vs. Postgres [link\|http://tweakers.net/reviews/649/7\|http://tweakers.net/reviews/649/7] But there are interesting comparisons of Linux vs. Solaris and Opteron vs. UltraSparc in that article as well. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #295,168 by crazy 10/26/07 3:23:47 PM Reply	Interesting I caved and installed Oracle to checkout the performance, as compared to Postgresql and Mysql. It's about 20 times faster for the simple stuff, and hundreds times faster for the complex stuff. Looks like I'm gonna write a big check.
Post #295,169 by boxley 10/26/07 3:43:41 PM Reply	did you look at db2? Quantum materiae materietur marmota monax si marmota monax materiam possit materiari? Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 51 years. meep reach me at [link\|mailto:bill.oxley@cox.net\|mailto:bill.oxley@cox.net]
Post #295,189 by crazy 10/27/07 12:36:28 AM Reply	Nope
Post #295,170 by Another Scott 10/26/07 4:01:10 PM Reply	Is 10g XE not an option? (I know little about DBs).
Post #295,190 by crazy 10/27/07 12:38:31 AM Reply	Nope Got about 8GB of data and 100GB of indexes. Plus, it doesn't do bitmapped indexes. [link\|http://www.oracle.com/technology/products/database/xe/index.html\|http://www.oracle.co...ase/xe/index.html]
Post #295,191 by admin 10/27/07 12:55:43 AM Reply	Did you do any tuning on Postgres? The default settings have gotten better, but there's a lot you can do with buffer sizes and so on that speed it up considerably. IIRC, there's also an in-memory version of MySQL; depends on how big your working set is, I guess. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #295,193 by crazy 10/27/07 1:04:15 AM Reply	Yup I gave it around 900MB to play with at one point. I rarely hit disk. It simply did things differenty from Oracle. And it was much faster than MySQL.

More MySQL vs. Postgres - (admin) - (7) - Oct. 26, 2007, 03:00:37 PM EDT

Interesting - (crazy) - (6) - Oct. 26, 2007, 03:23:47 PM EDT

did you look at db2? -NT - (boxley) - (1) - Oct. 26, 2007, 03:43:41 PM EDT

Nope -NT - (crazy) - Oct. 27, 2007, 12:36:28 AM EDT

Is 10g XE not an option? (I know little about DBs). -NT - (Another Scott) - (1) - Oct. 26, 2007, 04:01:10 PM EDT

Nope - (crazy) - Oct. 27, 2007, 12:38:31 AM EDT

Did you do any tuning on Postgres? - (admin) - (1) - Oct. 27, 2007, 12:55:43 AM EDT

Yup - (crazy) - Oct. 27, 2007, 01:04:15 AM EDT

iwethey.org

Your LRPD God[tm] was HERE!
48 ms