viernes, 8 de junio de 2012

SAP HANA vs. PostgreSQL - Small test

Someone left a comment on my blog SAP HANA vs. MySQL - Small test saying:

i think that if you retry this test using PostgreSQL you could have another surprises ;)


Of course, I'm always up for the challenge, so I installed PostgreSQL and did the same thing...


94ms for 1K records? Of course I was surprised...as in SAP HANA we had...


1.18 seconds...that's 0.094 seconds...almost 94% faster than SAP HANA...I started to think about and realized of course, that there was a significant difference between these two tests...first, PostgreSQL is doing the upload in background, while SAP HANA was writing all the "Statement 'insert...'" messages...so...remember that I told you that there was a faster method to upload data in SAP HANA? By just uploading a .CSV file?

Well...to make things interesting, I generate a new file with 3K records...here are the results...


It took PostgreSQL only 281 ms to load the 3K records...pretty fast, huh? 0.281 seconds...

Let's see how SAP HANA behaved...


Nice...it only took 116 ms to load...0.116 seconds...

Meaning that in this new test, SAP HANA was almost 58% faster...

Nice test for sure...and SAP HANA show why it's the fastest and coolest In-Memory Database out there...

Greetings,

Blag.

2 comentarios:

Anónimo dijo...

But is it worth it? A few ms faster, but also much more expensive. PostgreSQL is free (BSD-license), SAP HANA is said to cost $13.000 per 64GB unit.

We run PostgreSQL on a 512GB machine, handling a 20TB database. For free.

Alvaro "Blag" Tejada Galindo dijo...

Worth it?

SAP HANA edge for small-business with appropriate prices (e.g. $12K for a single node H/W + $2K for HANA for SAP B1 Analytics on HANA) to very large scenarios of greater than 100TB of memory.

Can you handle a whole company ERP system with PostgreSQL?

our recent 100TB benchmark runs on 16 nodes of IBM’s X5 servers each with ½ TB of main memory and processes 100TB of BW data in 300ms-500ms for operational reporting scenarios and 800ms-2s for ad-hoc analytical queries.

That's not a few ms faster...

You can read https://www.experiencesaphana.com/community/blogs/blog/2012/05/03/the-sap-hana-effect for more details...or watch this video http://www.youtube.com/watch?v=CsNuwHITwuU and let me know if PostgreSQL can do the same...

Greetings,

Blag.