Hi, It is slower in default settings of vmware environment. But today vmware has invented other things like SSD cache, vsan etc. If you can afford that kind of i/o improvments in your environment, it is very reasonable to continue on vmware, especially due to the ha things.
2015-07-03 14:37 GMT+03:00 Andreas Joseph Krogh <andr...@visena.com>: > På fredag 03. juli 2015 kl. 12:35:07, skrev Jean-Gérard Pailloncy < > jg.paillo...@adnow.fr>: > > 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 > andr...@visena.com > www.visena.com > <https://www.visena.com> > >
