VirtualBox vs. hardware for PostgreSQL

02.2016 / Category: / Tags: |

These days everybody is moving stuff to the cloud. In many cases there are good reasons to do so. Administering hardware is not what running a modern company is all about in most cases. The key advantage is that virtualization allows people to add and remove servers as needed. However, what does VirtualBox mean to performance?

Some time ago I posted a report on my observations with XEN. As my XEN tests are already a bit outdated I decided to run a small test on VirtualBox to see what happens to performance.

Hardware setup for VirtualBox vs. hardware

To get a rough estimate of it, I used my local desktop box, which is a 4 core Intel i5-4460 (3.2 GHz). I don't expect too much of a difference on better hardware. VirtualBox was given all CPU cores and 16 GB of memory. However, the amount of data used in the test never exceeds the amount of RAM available, so it is not an issue.

Compiling PostgreSQL

The first thing I did was to compile PostgreSQL to see, what happens to single CPU performance. Here are the results:

real hardware VirtualBox
configure 7.9 sec 15.5 sec
make install 2 min 31.8 sec 3 min 0.1 sec

To me this actually looks pretty good. The loss is somewhat acceptable and actually a bit smaller than expected.

Running pgbench

To do a brief test, I created a benchmarking database: pgbench -i -s 10

The output is a small database containing 1 million rows.

The interesting part is that a read-only test shows fairly large differences between “real” iron and my VirtualBox. On real hardware, I got around 77.600 TPS, while VirtualBox failed to exceed 19100 TPS. Interestingly, the tests show that the loss in performance is pretty consistent with what we had a couple of years ago on XEN.

In case you need any assistance, please feel free to contact us.

In order to receive regular updates on important changes in PostgreSQL, subscribe to our newsletter, or follow us on Twitter, Facebook, or LinkedIn.

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    CYBERTEC PostgreSQL International GmbH
    Would love your thoughts, please comment.x
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram