På fredag 03. juli 2015 kl. 12:35:07, skrev Jean-Gérard Pailloncy <jg.pailloncy@xxxxxxxx>:
Hi,
I work on a project that collects geolocalized data.
All data will be in PostgreSQL / PostGIS.
The small PostgreSQL databases will be on Linux guests on VMWare hosts.
The size of the main database will grow by 50 TB / year, 500 M row / day.
For the largest one, we plan to test different options.
One of them is to stay with Linux on WMWare.
Outside the questions about schema, sharding, I would appreciate if some of you have informations, benchmarks, stories about big PostgreSQL databases on Linux guests on VMWare hosts.
We have a 1.5T and growing DB which we started out hosting on VMWare, BIG mistake!
Never, ever, run a production DB on anything other then bare metal servers. Once we blasted VMWare's 8GB disk-cache our DB random-read speed went down to 1MB/s with 8K blocks (as PG uses), yes that's one megabyte per second!
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
