IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New 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..."
New 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.
New 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]
New Nope
New Is 10g XE not an option? (I know little about DBs).
New 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]
New 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..."
New 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)
         Interesting - (crazy) - (6)
             did you look at db2? -NT - (boxley) - (1)
                 Nope -NT - (crazy)
             Is 10g XE not an option? (I know little about DBs). -NT - (Another Scott) - (1)
                 Nope - (crazy)
             Did you do any tuning on Postgres? - (admin) - (1)
                 Yup - (crazy)

Powered by soy sauce!
61 ms